How to add attachments/forms in e-mail merge in MS Word03

[Gregg Ross]

I am trying to send out a mass email from a spreadsheet and want to do a few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out how to
add a hyperlink to add my .pdf brochure, but what I want to do is add an
attachment that is customized to there information. Any help on this would
be great. Thanks

 

[Doug Robbins]

See the article "Mail Merge to E-mail with Attachments" at

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


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

 

[Gregg Ross]

Doug, I appreciate your response. I already attempted to view that file and
I got confused as soon as I tried to create a Directory Merge as I didn't see
how to add an attachment there nor did I see a table being created. So I am
confused, is there anything you could help me with so I can understand better

 

[Doug Robbins]

You need to read the article very carefully and follow each step exactly.
If there is a separate attachment for each record, then the filenames of
those attachments need to be in a field in the datasource.

There are examples of how you need to setup the Directory mailmerge main
document and the result that you should get when you execute that merge in
the Setup portion of the article.

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

 

[SUNTEJ]

Dear Doug, I had used your VBA code, but one problem I am facing is that
only attachemnt is been forward and not the content, I want to send the
attachements with the content (body text), can u pls tell me where I am
wrong ?

 

[Gregg Ross]

I would like to discuss paid services with you. email me
(e-mail address removed)

 

[Doug Robbins - Word MVP]

You need to execute to a new document the mail merge that you want to be
contained in the body of the email and with the result of the execution of
that mail merge on the screen, run the macro.

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