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