Send Email Automatically.

[karthikcoep]

Hello,


I have data of 15 of my department collegues in an access table.


It includes their name, date of birth & Email Address.


I need to accomplish the following.


Say if tomorrow is Mr.X birthday.


I want to send a reminder mail to all of the other fellow about the birthday except Mr.X automatically.


I use groupwise client but i have outlook 2007 also. Is is possible. If yes how to do it.

 

[karthikcoep]

can somebody help please.
I need to do this urgently.

 

[pbaldy]

This shouldn't be particularly difficult, but a little tedious. I see 2 recordsets. First a recordset that finds anybody with a birthday tomorrow. Within a loop of that recordset, open a recordset on the whole table and loop through that, sending an email to everybody but the person in the first recordset.