Birthday reminder

[praneethone]

Dear All,

I would like have Cc: in birthday reminder workbook while sending.
Please do help me out in this regard.
Pls find attached file for requirement.

Thanks in advance.

Regards,
Praneeth

 

[sgmpatnaik]

@Praneeth

may be this will help, please try the below code in Tab birth-day reminder range("E9")

=IF(C9=TODAY(),HYPERLINK("mailto:"&D9&","&G9&"?subject="&C$4&"&body="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5,"$",B9),"@",$C$6),CHAR(10),"%0a"),"send e-mail"),"")

say you have another email id in G9 then email id generate as

abc@gmail.com,BBc@gmail.com

Hope it clear, other wise please inform

Thanks

 

[SirJB7]

Hi, praneethone!
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Search...), type the keywords used in the title when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
http://chandoo.org/forum/search/90623/?q=birthday+reminder&o=date
Regards!