VBA Code to Auto intialsend email & reminder email based on cell value

Afternoon guys,

This is my first post, bare with me lol

i recently started this tread over on Ozgrid but unfortunately haven't had a response. The guys over at Ozgrind have always been fantastic. I think due to the Easter break prob some are off etc hence lack of replies.

basically i have a workbook which i require to auto send a email if a cell value is met. in my workbook that cell value is based on today system date.

i will require the code to send 2 emails an initial email with the email subject ie first reminder etc & a second email with the subject 2nd email etc both emails are to be sent base on cell values. ie first email to be sent if cell A date is = to system date and 2nd email to be sent if Cell B value is equal to date in the cell ie 2 weeks from initail email. the second email subject should be ie email reminder.

and lastly the email body should contain cell values from cells: B,C,D,E,F,G,H

i have included a link to the original post over at Ozgrid.

i was hoping if some one could be kind enough to edit the code to do the above


Thanks Guys
http://www.ozgrid.com/forum/showthread.php?t=193989