Email merge with attachment

[Shirley]

I want to send a list of emails out with the following
requriements:

1. Each email has a customized attachment
2. Each email has a customized email body
3. Email body in HTML or Rich format
4. All emails sent out automatically

I have all the data avaliable in Access, but can't find a
way to automatically send emails out. I can use Access
(VBA) to meet the first two requirments, or use Word to
meet 4 and one of 1, 2, and 3, but not to meet all
requirements.

Any help is greatly appreciated!

Shirley

 

[Peter Jamieson]

I'd see if the fllowing article helps:

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

But assuming you are using Outlook as your e-mail client, you will probably
be better off asking this in an Outlook group (and/or visit
http://www.slipstick.com which has numerous useful info./tools related to
Outlook

One problem I have had in the past is that adding an attachment to an e-mail
programmatically may change the format of the e-mail (probably to rtf, but I
can't remember at this point).