Word mail merge / Access (1 Viewer)

Dick7Access

Dick S
Local time
Today, 13:13
Joined
Jun 9, 2009
Messages
4,051
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

Enthusiastic Amateur
Local time
Today, 18:13
Joined
Sep 21, 2011
Messages
10,838
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
 
Last edited:

Dick7Access

Dick S
Local time
Today, 13:13
Joined
Jun 9, 2009
Messages
4,051
Thanks, good start. It started me thinking. Yes, I do have their email in the DB.
 

Users who are viewing this thread

Top Bottom