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/...ttachments.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
"Pranay Shah" wrote:
Hi,
I have a very small doubt, exactly where do we save the macro, I mean do I
have to save the macro in the "Normal.Doc" file or in the mail merge template
which i have prepared. Or is it that I have save it in some other file
altogether.
Thanks
--
Regards,
Pranay Shah
"Doug Robbins - Word MVP" wrote:
You have not followed the instructions. It would appear that you have
execute the macro when you have the mail merge main document as the active
document, rather than a document created by executing the merge of that main
document to a new document.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Pranay Shah" wrote in message
...
Hi,
I tried the method mentioned in the article mentioned by you but now the
attachment is being mailed but with a blank email ie it doesnot copy the
contents of the mail merge document which i have prepared.
If can please let me know the steps to followed that would be of gr8 help.
Thanks.
--
Regards,
Pranay Shah
"Graham Mayor" wrote:
See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Pranay Shah wrote:
Hi All,
I am using mail merge to send emails to send a number of people but I
am facing 2 problems :-
1. How to attach a Excel file for each of the mails.
2. How to add subject line while using mail merge.
Thanks.