Hi,

I have been trying to use mail merge with attachment with the help of the
macro given in the link as mentioned below:-

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

But everytime run this macro it is not copying the mail contents from the
mail merge template which i have prepared instead it simply sends a blank
mail with the attachment.

I have followed folowing steps, please let me know where am I going wrong.
1. Create the mail merge template and save it.
2. Create a new word file with Email address and Attachment path mentioned
in it and then close it after saving.
3. Write the entire macro in the mail merge template created earlier. (I
have tried saving it in the "Normal.Doc" file also).
4. Add references for Outlook library.
5. Run pass the complete process of mail merge by selecting Email or
Directory option and create a new document with the individual mail in each
page.
6. Now go to that new document and run the macro.
7. Click "Yes" everytime it asks for sednign out the mail.
8. Macro ends and all files are closed automatically except the file which
has got the email and attachment details.

After doing all this the mail which is being sent is without any content and
only the attachement is attached.

It would be of great help if you can help me out with this as I have send
lot's of mails with different attachements to different people.

Thanks in advance.

Regards,
Pranay Shah