help needed in hyperlink formula

[Aditya Suryawanshi]

By using hyperlink formula we can send(auto draft)mail.

This was shown in Birthday reminder excel created by chandoo

https://www.youtube.com/watch?v=uwaoP3A3Qyg


Just wanted to know how to add "from" and "CC".

PFB the hyperlink formula used to draft mail with "to", "subject" and "mailbody".


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

 

[Luke M]

Check out this article by Data Pig. Shows how to add each of the email components.

http://datapigtechnologies.com/blog/index.php/emailing-from-excel-using-the-hyperlink-function/

 

[bobhc]

Double posting is frowned on, the forum members lead their own lives, work, home, interests ect ect, and they answer questions and offer help willingly and for free. The world is a 24hr place and members live around the globe in different time zones, you may be up and about others may be sleeping or enjoying time with their families.


This post has been closed.


http://chandoo.org/forums/topic/how-to-add-cc-and-from-in-birthday-reminder-excel