Auto Send E-mail

[George]

In my database one of the fields is Guardsmen's birthdate.
Is there a way to auto send an e-mail to a list of people
based on their birthdate.

Thanks - George

 

[ALESSANDRO Baraldi]

In my database one of the fields is Guardsmen's birthdate.
Is there a way to auto send an e-mail to a list of people
based on their birthdate.

Thanks - George

You need a function that extract with a Query or Recordset
the List, and send Mail with one of many method supported
to sending mail:

CDO
MAPI
WINSOCK
OUTLOOK
ecc.....!

This function can be runned on Start_up with Autoexec(Macro)
and only once for day, sò you can save in some place(Registry
or INI file or Database Property) the effect.

Bye.