Generate e-mail from command button??

[option]

Hey guys,
I dont know if it is possible, but how would I send an email from Access using a List box as the list or recipients and a combo box as my subject. Take a look at my database here: select a report from the combo box. Now, the list that appears below is my distributionlist. I just want to send that list an e-mail with the subject being the report name you choose in the combo box. Any ideas?

 

[ajetrumpet]

you can start here:

http://www.access-programmers.co.uk/forums/showthread.php?t=158170

that uses a table as the list, but the same applies to a listbox extraction. To get an idea of how to get the selected lines from a list box, take a look at Lister's example here:

http://www.access-programmers.co.uk/forums/showthread.php?t=136282

 

[Pingo]

Take a look at microsoft templates that came with access 2007. They do email sending with macros, and maybe it will help you.

 

[option]

ajetrumpet, thanks for the links. I'm checking those out now. Pingo, I appreciate the suggestion, but I don't have Access 2007 unfortunatly. I'm using 2000. Thanks to the both of you!