Hello i am looking for a VBA coding that allows to have an email once
one of the employe has an expiry date to be renewed
Example :
Sheet name : expiry dates
A1= Employee Name
B1= Birthdate
C1= Passport renewal date
D1= Driving license renewal date
E1= Visa card renewal date

I want a text informing me that this employee needs the following* to
be renewed for him

Best Regards

Hi Tia,
take a look at Ron webpage

http://www.rondebruin.nl/mail/change.htm

"Tia" wrote:

Hello i am looking for a VBA coding that allows to have an email once
one of the employe has an expiry date to be renewed
Example :
Sheet name : expiry dates
A1= Employee Name
B1= Birthdate
C1= Passport renewal date
D1= Driving license renewal date
E1= Visa card renewal date

I want a text informing me that this employee needs the following* to
be renewed for him

Best Regards