Send individual emails from a Query result

[blanchard]

Hello all,
Ok what's the best way to send individual emails from a Query result.

I have a search button on a form that looks for any month of the year the user types in. The results show the following fields - Name, Date of Birth and Email Address.

Now I want to send an email with an invitation to a venue to all in the Query result, how best would I achieve this?

 

[pbaldy]

This should get you started:

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