| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send email to a email address 7 days before the due date
Hi,
I have a sheet to monitor the contracts where start and end date of the contract is mentioned in columns i.e. C2 (01 Aug 2012 Start date) D2(31 Aug 2012 End date). My requirement is that 5 working days before the end date, A email should be sent by the macro to a predefined address with following details Subject: Contract expiry 31 Aug 2012 In body: Paste special the column: A2 to E2 My data base looks like - A1 B1 SL no Name |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send email to email address in column | Excel Programming | |||
| How can I send file by different email address (to; cc and bcc) | Excel Programming | |||
| Send data from Excel in email from specific email address | Excel Programming | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Threaded Mode
