Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Macro to send email 5 days before a date mentioned in Cell

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 (i.e. like for 31 Aug 12 contract contract be sent on 27 Aug 12) 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send email to a email address 7 days before the due date [email protected] Excel Programming 1 July 23rd 12 10:09 AM
Send email based on date value Billie Mac[_2_] Excel Programming 7 October 15th 09 05:16 PM
Excel VBA macro to send email attachment from default email client wifigoo Excel Programming 2 April 12th 08 03:54 PM
Can Excel auto-send an email on a given date? dannykray_z Excel Discussion (Misc queries) 1 April 18th 06 07:43 PM
Macro to send mail to email id mentioned in a particular column palanivelan Excel Programming 1 July 13th 03 02:32 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"