Word mail merge / Access (1 Viewer)

[Dick7Access]

For then last 25 years I have sent out my church support letter each month (approx. 35) with a mail merge. I type one letter, in Word, set place holders for names, address etc. In Access I type S in the send field and of course my printer spits out the same letter 35 times with different names and addresses.

However, I now have 5 churches that want email attachments instead of snail mail. This last time I took same letter for 5 for email (one at a time) set S in send field loaded letter and saved it to a sperate folder. Then in email I pull up their email address and attach the appropriate letter. Had to do this 5 separate times. There has to be an easier way. Any suggestions.

 

[Gasman]

I think you will need to add a field to indicate what method to use.
Then search here for email attachments. It has been asked numerous times. In those posts, is also how to use the email addresses. I assume you already have a field for the email address?

Here Dick
Look here

 

[Dick7Access]

Thanks, good start. It started me thinking. Yes, I do have their email in the DB.