• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Birthday template

Diane Hall

New Member
Hi , I made the birthday template from instructions on this site, It works great, but it opens two emails in outlook mail, I can't figure out why, its annoying really. my co workers want me to fix it. lol, but I can't seem to figure it out. the code is =IF(C15=TODAY(),HYPERLINK("mailto:"&D15&"?subject="&$C$2&"&body="&SUBSTITUTE(SUBSTITUTE($D$3,"$",B15),"@",$C$4),"send wishes"),""). Please help me solve this. The emails that we use look like this: lastname,firstname NHA firstname.lastname[EMAIL='firstname.lastname@ourcompany.com']@ourcompany.com[/EMAIL]. Thanks for any help you can give me on this opening two emails everytime we click on Best wishes link to send a birthday email. thanks
 
Back
Top