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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send email to a email address 7 days before the due date
Sorry, Full post was not saved in the earlier section here it is
--------------------------------------------------------- Hi, I am a novice in programming, hence required the help of expert in this forum. I have a sheet where all the contracts are listed with start and end dates. The date base looks like as follows - A1 B1 C1 D1 E1 Sl Name Start End Contract Manage Name 1 XYZ 01 Aug 12 31 Aug 12 Mr. ABC 2. FGH 06 Aug 12 24 Aug 12 Ms. ASE My requirement is a macro that can send an email to a fixed email ID (i.e. ) 5 working days before the contract end date with following details Subject: Contract end date 31 Aug 2012 Body of Mail: Paste special A2:E2 row Thanks and regards in advance Rajat |
Reply |
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) |