andytpl
07-08-2008, 10:52 PM
I have workbook that record the incoming letters. Each of these letter need to be responded to within 60 days from the date of receipt. The data are startingin row 6 and in Col D is the date of receipt and Col E is to record the date of reply. I need to be able to run a macro which perform the following task.
1. If Col E is blank or 30 days or 40 days or 50 days or 60 days past the date or receipt, send out a email message to an email address in Col G; cc mail to email address in Col H.
2. Once the email is sent in Col I the date sent is automatically keyed in.
3. This macro should not be repeated within 48 hours from the last opening of this workbook.
4. The message of the email should contain the following sentences.
"You have not response to the letter in the Letter Register. Please response within the next 2 days. The letter reference is in Col B
I would appreciate any help with this request.
1. If Col E is blank or 30 days or 40 days or 50 days or 60 days past the date or receipt, send out a email message to an email address in Col G; cc mail to email address in Col H.
2. Once the email is sent in Col I the date sent is automatically keyed in.
3. This macro should not be repeated within 48 hours from the last opening of this workbook.
4. The message of the email should contain the following sentences.
"You have not response to the letter in the Letter Register. Please response within the next 2 days. The letter reference is in Col B
I would appreciate any help with this request.