Hello All,
I have searched forums and cant seem to find formula to work this out.
If Column A Month and Year = ColumnB Todays Month and Year then send email
This is the formula im currently using.
=IF(C9=TODAY(),HYPERLINK("mailto:"&D9&"?subject="&$C$4&"&body="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5,"$",B9),"@",$C$6),CHAR(10),"%0A"),"send e-mail"),"")
Any clues??
Many Thanks
Last edited by HACCStaff; 04-15-2013 at 12:00 AM.
Hi and welcome to the forum
You cant send an email with a formula, you need to do this through VBA (and my VBA sucks)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This link may help with VBA
Good LuckHTML Code:
Hi Wagstaff,
The above formula works if you have a full date... i just dobnt know enough about the coding to select only todays month and year.
Thanks for the link will have a look
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks