Email multiple recipients from a table

[skwilliams]

I have a couple reports which I would like to email to users whose email addresses are contained in a table.

How can I do this?

Thanks.

 

[chenn]

Open a recordset based on the table and run a loop to send the reports. There are several ways to send emails via VBA. Search the forum for email and you will find plenty.

 

[Travis]

See http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=58212&highlight=email

 

[skwilliams]

That worked perfectly.

Thanks a million!