e-mail Merge (Access 2007)

Topic

New Reply

I have an access database which I have been using as a mail-merge data source in MS Word. The data merged includes snail-mail address data, Monthly C/f account balances, charges and payments and a closing balance. It works great as I can fit 3 to a page and it fits neatly into a window faced envelope. I now wish to merge some of the data to E-MAIL where the recipient has an e-mail address, and continue Snail-mail for those who don’t. Can anyone point me to an article where I might learn how to merge-to-e-mail from my tblMailMerge table, as a part of the body of the e-mail rather than as an attachment.

Reply | Quote

Replies

Word has an option to send documents as attachment or not in the General tab of Tools | Options. If you clear this check box and set up a mail merge to e-mail, the text should go out as the body of the emails.

Alternatively, you could create the e-mails in code in Access by looping through a record set and using DoCmd.SendObject.

Reply | Quote

Thanks Hans, I’ll give it a go

Reply | Quote

Hi Hans,

Still having a little trouble with this.
Financial Data is in an Access database, as is the snail mail adrress. No problem with this as I merge data to priinter.
However, how do I mail merge to e-mail, pick up the Financial data from Access table and get it into the body of the e-mail and the e-mail address from Outlook. If I create a field in Access for e-mail address, how to I get this from Access into the ‘To:’ field of n e-mail.

Reply | Quote

If you want to send individual messages, you should put the e-mail addresses in the Access data source, otherwise the mail merge doesn’t know which e-mail address belongs with which message.

I have no experience with Office 2007, but in Word 2002 and 2003, you will be asked to specify the field that contains the e-mail address in the very last step of the Mail Merge Wizard (aka task pane), when you click “Merge to e-mail”.

Reply | Quote

Thanks for quick response, will play some more.

Reply | Quote

Sorry to be so late to the party, but if you haven’t resolved this issue, I would suggest doing the whole thing in Access. We have a client who sends out an email with a customized body and an attached Excel workbook to 600 or so people who do have email, and sends a printed copy to those who don’t have an email, or can’t open an Excel workbook. We do it all in Access with automation to Outlook. If you would like some sample code, I would be happy to post it.

Reply | Quote

Hi Wendel,
Started reading some of my old posts, and found this one 12 months old to the day.
Problem has still not been solved. Have even resorted to freeware third party options, but these cause HTML currency formatting problems when balance is negative.

Would be interested in looking at some code, as issue has raised its head again with Australia Post increasing cost of postage stamps.
Also need to attach a pdf document (same for all recipients), and have been unable to do this from word.

Thanks in advance.

Reply | Quote

If you search this forum for outlook.application you will find numerous examples of automating Outlook from Access, including examples of looping through a recordset and of attaching files.

Reply | Quote