Autoemail based on date in cell

[gjb1927]

Hi All

Would appreciate some help with this, im new to VBA.

Here's what I would like the macro to do.

I have a range of dates in column U. A staff members PIN number in column G (I can create the e mail address in another column, no problem, or ideally the address part of the email can be added just to the number in the column)

I would like the macro to go down the list and find all the entries that are 14 days prior to the date in column U and autoemail a notification, not add any attachments, to the staff members email / PIN number. I anticipate about 10 - 15 e mails being sent to different recipients

Ideally I can point the title and body of the message to a cell reference on a new sheet. The body etc will be a template.

I would like this to be sent out once the spreadsheet is re calculated and the dates are worked out. Possibly a message box that says "Would you like to generate auto email etc.."

I know this is a big ask.....I have searched the forum but i cant find anything that matches what I intend my macro to do, and not being good enough to amend some of the code already posted.

Your help is greatly appreciated

Gareth

 

[gjb1927]

Bump

 

[gjb1927]

any takers?

ta

 

[VoG]

Take a look here http://www.rondebruin.nl/sendmail.htm especially http://www.rondebruin.nl/mail/change.htm