Simple e-mail problem

[Orfeas]

Hi!

I have a query in my dtabase that produces different e-mail addresses every day.

I want to add a button in my form to send a simple message to everyone. The message is the same for all.

Any ideas how to do that?

 

[jeremie_ingram]

Iwould use VBA to accomplish something such as this. First you would have to create a loop to build a variable that would hold all of the names. I recall along time ago in one of the classes I took an example of just such a thing. The loop ran adding to that value of the variable the e-mail address' separated by a colon, then ran the DoCmd.SendObject
docmd.SendObject acSendReport,rptReportToSend, html, Varible,,,"Desired Subject Here”,” Additional Message text here"

Try playing around with the send object command behind the on click event of the button you want to trigger this action. Also look through the code area of the forum for good examples in building that variable to contain all of the address you have into one long string.