How do I use Access to email Word docs to multiple address? 1

[shkgrad]

I have an Access database with names and emails. I have been able to create a document in word and use the mail merge, it works perfectly, but I have to use snail mail.
I try and send the same document as an e mail and it just won't work. Is there a way to group a filtered recordSet and have Access merge the data into a Word "form letter" then send it as an email?

 

[PhilipSchroevers]

You should have acces to the Document class from within Access. Open your main document as a new Document and set the values of its MailMergeDataFields from values from the appropriate record in your Recordset.
You can then either use the Mailer (etc) methods of the Document to send the mail, or acces the Outlook library, create a mailmessage for each document and add the document as an Attachment.

 

[jioek]

http://www.mach5.com

great program for $100.00

joek