SendObject / Automatic Email

[jjcyeshua]

Hi folks, vba guru,masters,experts.... I need help. How can i automate or send report to a list of email from a query that i created. I was able to used SendObject macro but only for a specified email, now i need to make it dynamic. Any ideas, or anyone who could point me to the right path. Oh one more thing just an fyi... kinda newbie about vba... Thanks in advance

 

[pbaldy]

This should get you started:

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