Email each name from a query result (separately)

[vangogh228]

I have searched and searched... but I just cannot find this. I know it has to be in here somewhere. Any help is greatly appreciated.

I have a query called "MyLateProjects" that shows results based on a specific number of days since the "project" was entered in to the database. I need to be able to send a "You are late X days" email to each of the project submitters from the values in the records of the query result. I have the fields, for example, of "emailaddress" and "Projectnumber" that I need to include in the To: line and Subject line, respectively. So, if I get five results, I need it to send five separate emails.

Like I said, I have searched and searched, and I cannot find a way of getting this done. I can send the first one from a button if I show the results in a form... but I don't know to automate the send operation as part of the query, nor how to get a separate email sent for each record (would this be a loop of some sort??).

THANKS!! ALL HELP IS APPRECIATED!!

Tom

 

[pbaldy]

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

 

[vangogh228]

Thanks...

It looks like I've got some homework to do, as I have NO idea how to interpret much of this code. Thanks again. Hope it works.

 

[pbaldy]

Some of it is irrelevant to you, unless you want the bit about showing the user which record it's working on. I would drop that stuff. And I just noticed it doesn't show an actual email method. I'd use DoCmd.SendObject. It will be a good learning experience though!