Mailto link in excel with subject and body

**whinston** · 08-10-2009, 09:07 AM

I am trying to send out an e-mail from excel with all kinds of combined info. Here is what I have so far, which works to send out an e-mail to a certain address with a compiled subject. No luck with inserting the BODY of the e-mail yet from a certain cell.

=HYPERLINK(CONCATENATE("mailto:",E32,"?subject=",F32))

Also, How do I make the text in each of these cells read "send e-mail" rather than the whole jumbled mess that is currently in there from the combination of the cells?

Thank you!
Whinston

**romperstomper** · 08-10-2009, 09:50 AM

You can't set the body of an email in a hyperlink. For the display text, you would use:
=HYPERLINK(CONCATENATE("mailto:",E32,"?subject=",F32),"Send e-mail")

**DonkeyOte** · 08-10-2009, 09:54 AM

For once I would disagree R

=HYPERLINK(CONCATENATE("mailto:",E32,"?subject=",F32,"&body=",F33),"Send e-mail")

where F33 contains body

**romperstomper** · 08-10-2009, 10:19 AM

Oh dear. That settles it - I'm not answering anything else today as my mind is clearly not working!

Thanks for the correction, DO.

**DonkeyOte** · 08-10-2009, 10:43 AM

never a good sign is it R... as I understand it you can pass subject, body, cc, bcc - the syntax is per any other url ie ? for first variable and & delimiter thereafter (and use HEX codes to format)

**romperstomper** · 08-10-2009, 10:47 AM

That was about the third piece of misinformation I've posted today in various forums! I blame lack of sleep...

I think I got confused with SendMail.

**muratis** · 11-28-2012, 12:19 PM

Originally Posted by whinston

I am trying to send out an e-mail from excel with all kinds of combined info. Here is what I have so far, which works to send out an e-mail to a certain address with a compiled subject. No luck with inserting the BODY of the e-mail yet from a certain cell.

=HYPERLINK(CONCATENATE("mailto:",E32,"?subject=",F32))

Also, How do I make the text in each of these cells read "send e-mail" rather than the whole jumbled mess that is currently in there from the combination of the cells?

Thank you!
Whinston

This code includes all the parts of an email..

Please Login or Register  to view this content.

Don't forget to add your signature

**sarav99** · 08-08-2019, 04:58 AM

Is there a way to automatically add an email signature?

**dominicb** · 08-08-2019, 05:21 AM

Good morning sarav99

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread