Hi,
Need a macro,which will give an automatic mail to an id,before 15 days of the
expiry date in column I.Attached file inside.
Hi,
Need a macro,which will give an automatic mail to an id,before 15 days of the
expiry date in column I.Attached file inside.
Ron de Bruin's site has all manner of mailing examples, eg: http://www.rondebruin.nl/mail/change.htm
(we're assuming Outlook is your default mail client unless you specify otherwise)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
The mailing part is ok,but I need the code for the situation like this -\
The mail will shoot 15 day before the "expiry date"for each date in column 'I"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks