How to email a report to a list of emailusing outlook

[cafe_jay]

I would like to email a report or form to a list of contacts.

I currently have the simple button that when clicked it opens access and i have to put the contact info, the subject, etc. myself.

this is the simple macro for EmailDatabaseObject.

But i would like the recipient info to be pulled from a seperate table not in the report. I tried doing To = ([TableOfEmails].[Emial]) but I get an errors.

Help Me. Thank you.

Regards,

Cafe Jay

 

[pbaldy]

You can't reference the table that way. Since it's multiple addresses, you'd have to open a recordset on the table and loop through it, building a string appropriate for email. Here's an example you can adapt:

http://www.granite.ab.ca/access/email/recordsetloop.htm

 

[cafe_jay]

I tried implementing the info from the link you sent me but it didn't work. Or maybe i just wasn't able to get it to work. Also I dont want it to automatically email, I would like for outlook to open then the user can press send themselves in outlook.

 

[pbaldy]

You can have the code send the email or just display it. The key is to use the loop to build a string of addresses. What is your code so far?