Assuming you would like a tutorial on how to create automatic text in an email using Excel:
- Open a new Excel workbook.
- Enter the following data into cells A1 through D4:
| To | Cc | Bcc |
Name | John Smith | Jane Doe | |
Address | john@smith.com | jane@doe.com | |
|
Subject |
Hello! |
- 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?".
- (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.