mailing a report: getting addresses from records?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi,

I've got the following situation (using MS Access 2000):

There's one table containing different persons with their respective
e-mail addresses. I'd like to e-mail them now an report created in
Access. I've already created the button using the wizard but the problem
is my Access application then only opens an e-mail message containing
the report as an attachment. What I would need now is getting the e-mail
addresses from the database automatically into the TO: field!

Is that possible and if yes, how?

Thank you very much, any help is greatly appreciated!

Jerome
 
Try the EmailSenate.mdb sample database at my website, which demonstrates
sending multiple reports to multiple email addresses gotten from a table:

http://www.datastrat.com/Download/EmailSenate2K.zip

PLEASE do not actually send the emails while testing. The data is over 5
years old and the Senators, particularly those no longer in office are
getting really tired of getting the same report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Have you had ex-Senators made formal complaints about your sample database
yet??
 
Hm, small problem here ... If I select the senators and the report and
then click "Send", an e-mail message opens with the attachment, but the
TO: is empty?

Am I doing something wrong??

ps. I don't want to send it, I just want to see if the TO: gets filled ...
 
Back
Top