Hi All,

I have a small problem, the answer to which I have seen somewhere before but I cannot find it now.
Please forgive the lack of test file but my company blockers are stopping it.
My excel file contains a list of documents that are sent to signature, and we use it for tracking purposes. Basically I want to have excel send an e-mail to only one recipient, contained in column G, on a certain date in column H, for a subject document in column C. (or possible 2 days before)
The Subject of the mail will be the document title, I.E. "Re: (reference cell with document title)" and a simple message "This signed document is due to be returned today" to the recipient identified on the same row.

So, for example, Document DC4568976 (C4) is due on the 4/01/12 (H4) from the signatory (G4). Column G contains the e-mail address, with hyperlinks removed. On the 4th Jan the recipient will receive the e-mail to remind them to sign and return the document.

I have read Ron de Bruins tips but I can only find one code for sending a message, but not date specific.
The workbook is kept in a general drive and not on a specific desktop machine. A further question is will the code self generate the e-mail without the file being opened?

Many thanks for your help in advance, and merry christmas.

JD