Send email to each result of a query

[MICKI0220]

I have a query that gives an "action date" and the "project name" and who is responsible for that actions "email" and name. What I need to do is send an email to each of the result of the query stating that they need to follow up. The email should take the date the action is due and puts it in the statemnt, the name of the project and places it in the statement and then looks at the email address in that record and sends that statement to the email address. My results list could have 1 or 10 or more people that have to follow up on a project. How can I accomplish this? I have done something similiar with a macro and a report but that was the same persons email address everytime a part needed to be inspected, this could be anyone's email address.

 

[HarleyQuinn]

What have you got so far?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com

 

[MICKI0220]

I've the got the results of the query with the dateadd function, that's it. From there I don't know where to go with multiple results. For instance. My query takes todays date and adds 7 days. If an action by date = that day then it gave me two projects that need to be checked on. Both are by different people so my query gives me the project name the action date and the email of the person who needs to be notified. From there I don't know how to notify each person separately. I need to send an email saying..."You have a project that needs a follow up"...then it should insert the project name and the action date and email it to the email address of that person in the record. Then loop back to the next record and do the same till eof.

 

[PHV]

I'd use a Recordset and the DoCmd.SendObject method inside a loop reading the recordset.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886