mailing a report: getting addresses from records?

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
 
A

Arvin Meyer

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
 
V

Van T. Dinh

Have you had ex-Senators made formal complaints about your sample database
yet??
 
J

Jerome

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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing multiple reports 1
Multiple e-mail addresses in e-mail mail merge 7
avoid duplicates on label report? 5
Access 2000 Report, mailto 3
How to delete or overwrite an attachment file 3
Problem Exporting Images Over 5 MB to PDF 2
Can I do a mail merge from Access to Outlook for e-mailing? 2
Blank Report as Attachment 1

Top