How do I add attchment to an email mail-merge?

[IndustryGuy]

Having generated a CSV file containing a list of contacts with allk their
details, I know how to go through the process of doing a mail-merge as an
email. And what a neat feature it is!

However, I now need to do the same but to add an attatchment (sending out a
monthly price list update to customers). I cannot find any way to add an
attached file. The same file goes to everyone, I'm not asking to customise
the file (now there's an idea).

All help apprecaited!

Rob.

 

[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

 

[Graham]

HI, I've tried following the routine in the link below, but to no avail!.
I have a basic Word document, set up as my main mail merge document. I have
my data source in an Access query, and have previously successfuly mailmerged
to email - following previous advice.
I now simply want to include the same two .pdf files as attachments to all
the recipients. Is there not a simple/work around way of doing this, without
getting into the (far too) complicated world of VBA etc. etc.
I could probably send 150 + individual emails + attachments long before I
ever work out how to master the info in the link!
I do though admire anyone than can comprehend what they're doing with VBA!

 

[Doug Robbins]

Hi Graham,

Creating the macro is a one time exercise and all the hard work has really
been done. See http://www.gmayor.com/installing_macro.htm

or See the article "What do I do with macros sent to me by other newsgroup
readers
to help me out?" at:

http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

Once you have that macro created, you can use it any time you need to send
an email with attachments.

The only alternative is as you suggest, doing it all manually.


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

 

[Dimitris]

Hi Graham,

Creating the macro is a one time exercise and all the hard work has really
been done. See http://www.gmayor.com/installing_macro.htm

or See the article "What do I do with macros sent to me by other newsgroup
readers
to help me out?" at:

http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

Once you have that macro created, you can use it any time you need to send
an email with attachments.

The only alternative is as you suggest, doing it all manually.


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