Auto E-mails

Hey everyone,

I currently have a macro that allows me to send a delayed e-mail via outlook which works well for my own personal reminders (it also looks a little fancier than just using Task Scheduler).

However now I would like to create a macro that runs automatically when a specific date is reached in a cell.

Edit: I have managed to find / create something for my tailored desires, but there is a change I would like to to make that I am unsure of, as most of this coded has been taken from elsewhere.

Please Login or Register  to view this content.

Essentially, instead of eBody = "Dear " & Cells(i, 1) & vbCrLf & vbCrLf & "Please note that the quantifit." I would like the "Please note that the quantifit." part to be taken from a cell, so I can write it in excel. This will allow me to personalise the e-mail more, rather than just a generic message. I would like it to say something like 'Please note the following certificates have experied: ...' so obviously writing that in the cell would be far more easier.

Cheers!