Creating an email

**gandyling** · 11-10-2011, 03:21 AM

Hello everyone

Please can someone help me. How can I create a "link" on a spreadsheet so that when I click on it it opens up an email to a certain email? and would also be possible for the information on that spreadsheet to be transposed to the email?

Thanks again for your help.

**TMS** · 11-10-2011, 03:30 AM

Look at Ron de Bruin's web site for some ideas.

http://www.rondebruin.nl/sendmail.htm

Regards

**gandyling** · 11-10-2011, 04:33 PM

Is there a more straight forward way that anyone knows of?

**TMS** · 11-10-2011, 04:48 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Whizbang** · 11-10-2011, 05:30 PM

For simple emails, you can use the HYPERLINK function.

=HYPERLINK("mailto:[email protected]?subject=Testing&body=Test","Send Email")

If you want to insert sheet data, you can concatenate it into the link location string.

e.g.

=HYPERLINK("mailto:" & $A$1 & "?subject=" & $A$2 & "&body=" & $A$3,"Send Email")