Emailing reports from Access

[David D]

Hi,

I have a membership database and I am currently running a report every month
that generates renewal letters.. then I print and post these.. easy..

I have been wondering as I have the members email address in my database
already is it possible to do the same via email.. so far my attempts have got
stuck with the fact the report is one long document with something like 50
pages (ie. 50 renewal letters for 50 different people).. is it possible to
split tis up so there are individual letters and then how do I do about
addressing the individual letters based on the email address in my database???

Any suggestions much appreciated

 

[Larry Linson]

You can write VBA code to loop through your file and use SendObject to send
an e-mail to each member in the Renewal Reminder file. On the other hand, I
have found that creating a text list of the e-mail addresses and using copy
and paste into one e-mail to all who need reminding has worked as well as
the previous membership chairman's practice of sending a personal e-mail to
everyone whose membership was expiring.

Larry Linson
Microsoft Office Access MVP