Attaching a Excel File in the mail merge and adding Sub. line in E

[Pranay Shah]

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.

 

[Graham Mayor]

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Pranay Shah]

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.

 

[Doug Robbins - Word MVP]

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]

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

 

[Pranay Shah]

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

 

[Doug Robbins - Word MVP]

Please read my response to your message of yesterday. Also you need to
re-read the article and follow the steps exactly.

The macro should probably be stored in the normal.dot template or in a
template that you store in the Word Startup directory so that it is treated
as an addin.

--
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]

Hi Robbins,

Thanks for replying back and for your patience with me.

But as I had mentioned in my last reply I have saved the macro in the
"Normal.Doc" file which is the default file to treat any macro as an add-in.
Also I have ensured that the New doc which gets generated after using mail
merge is active. I have again tried it and I am still facing the same problem.

I don't know where I am going wrong, I have read the article again and again
to see if I have missed out any thing but there is nothing which i can think
of.

 

[Doug Robbins - Word MVP]

From what you have written in earlier messages, you changed the mailmerge
that contains the information that you want to appear in the body or each
e-mail message into a Directory Type Mail Merge. I told you that you
should not do that and that that mailmerge MUST REMAIN AS A FORMLETTER TYPE.

You are going wrong because you do not read and follow the instructions
precisely.

--
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