My objectif is to export and send mail with a word document (reports), so, I use tihs steps :
1/ Export records to server in an excel files .
2/ When the excel export file will be open automatically in the server , An excel macro will be RUN to save data to a word document. Every line in the excel file will be save in a new document word that will be saved as Line_Name( which is slected in the 2nd column of the line ) .
3/ Now I have the docs and I want to send mail with that attached files , then delete them from the server ..