Creating Email Links

[psycoperl]

I would like to know how can I create a cell that I can use as a pseudo button (so that it would work with both Excel Apps and Excel Office 365 Online) that when the user clicks on it, it would open their email client to send the email.

=CONCATENATE("mailto:myEmailUserID@.mySchool.myUni.edu?subject=",$C$6," [FILE ID ",$H$3,"]?body=The file ", $C$6 , "-", $H$3, " is ready to be processed")

Is this possible? I saw the Insert Link option which would allow me to create a link but it would not allow me to use a formula to get the subject line or pre-set a body message.

 

[Dan_W]

Try changing the ? before body to an &. So, for example, the final output looks like:

mailto:SendToMe@MyPlace.com?subject=Discussion Topics&body=To be discussed

I hadn't appreciated that the Insert Link dialog doesn't allow insertion of the Body text. In any event, you can get the same effect by using the HYPERLINK formula:

=HYPERLINK("mailto:SendToMe@MyPlace.com?subject=Discussion Topics&body=To be discussed","Click me!")

This will (hopefully) display the hyperlinked text: "Click Me!". I haven't tested it for 365 Online, but it should work.

 

[psycoperl]

Thanks
This worked