Auto Subject & Body email hyperlink ?

**mitelkm** · 08-27-2010, 02:30 PM

Hello all,

Thanks for reading..

I was wondering if there was a way if: I click on a cell, it automatically opens a new email, with the cell contents as the subject line and a generic message for the body?

Is this possible?

Right now, if I create a hyperlink in excel it opens a new mail message for me, but does not fill in the subject or body...

Thanks again..

**mitelkm** · 08-27-2010, 02:57 PM

I figured this out myself. Thank you anyway!

**DonkeyOte** · 08-28-2010, 03:32 AM

I'm glad you resolved however on forums such as this we would ask that you post your solution as it may well benefit others.

For the benefit of others:

=HYPERLINK("mailto:ronald@mcdonald.com?subject="&A1&"&body=What%20a%20Wonderful%20Day%0A%0ARegards","send email")

**shared** · 10-17-2012, 02:12 AM

I used this formula in google spreadsheet with Google chrome browser and Microsoft Outlook 2007 as my default email client

=HYPERLINK("mailto:test@gmail.com?subject=test","test")

Observe that after executing the above formula, subject of the mail is not pre-populated with the data given

Issue is observed when i was trying with different browsers...

Please reply me fast..

**arlu1201** · 10-17-2012, 05:47 AM

shared,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.