Excel Guides

Automatic Text in an E-mail in Excel

Assuming you would like a tutorial on how to create automatic text in an email using Excel:

  1. Open a new Excel workbook.
  2. Enter the following data into cells A1 through D4:
ToCcBcc
NameJohn SmithJane Doe
Addressjohn@smith.comjane@doe.com
Subject
Hello!
  1. Click on cell E1 and enter the following formula: =HYPERLINK("mailto:"&A2&"?subject="&C2&"&body="&D2, "Send Email") This will create a hyperlink in cell E1 that, when clicked, will open up a new email addressed to John Smith with the subject "Hello!" and the body of the message containing "How are you doing today?".
  2. (Optional) To change the appearance of the hyperlink, right-click on cell E1 and select "Format Cells." Under the "Number" tab, select "Custom" from the Category list. In the Type box, enter the following: \0#\,"Send Email". This will remove the underline from the hyperlink and display the words "Send Email" instead of the actual address.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.