Using Hyperlinks to send email

LostCause

Board Regular
Joined
Jul 13, 2006
Messages
99
Firstly, thanks for reading.

I want a Hyperlink which when clicked creates a new email in Outlook and fills in some of the fields.

I have tried using:




My problem is there is no space to put the body of the email. Does anyone know of a way of doing this?

Thanks.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
=HYPERLINK("mailto:address@somewhere.com&subject=this is my subject&body=body of the e-mail goes here","what to display in the cell goes here")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,730
Members
410,702
Latest member
clizama18
Top