Sending Emails with different criteria in Access

[Hemish]

Hi i'm trying to send emails in Outlook 2000 via Ms Access 2000. How do you write in the Subject of an email and in the body part?

The information will be coming from a query so different customers have different information. There are 4 different email templates it can be, providing what criteria i want the customer to get that email.

Eg

Email 1 - Wrong Address
Email 2 - Order Processed
Email 3 - Refund
Email 4 - Discount

Its like a mail merge document but i need the information to be emailed in MS Outlook 2000.

Do you have any ideas please

Thanks in Advance

 

[pbaldy]

You'd want to open a recordset on the query. Within a loop of the records, you can evaluate each one to decide which type of mail to send, and fill in the subject and body accordingly. Some sample code here:

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

 

[Hemish]

Hi thanks for your help it work i used the link you supplied me and i went to another link which was on that website