+ Reply to Thread
Results 1 to 4 of 4

If Column A Month and Year = ColumnB Todays Month and Year then send email

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Mt barker,Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    If Column A Month and Year = ColumnB Todays Month and Year then send email

    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.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,910

    Re: If Column A Month and Year = ColumnB Todays Month and Year then send email

    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

  3. #3
    Registered User
    Join Date
    05-09-2009
    Location
    Manchester,England
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    58

    Re: If Column A Month and Year = ColumnB Todays Month and Year then send email

    This link may help with VBA

    HTML Code: 
    http://www.rondebruin.nl/win/section1.htm
    Good Luck

  4. #4
    Registered User
    Join Date
    04-09-2013
    Location
    Mt barker,Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: If Column A Month and Year = ColumnB Todays Month and Year then send email

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1