Tip 33: Sending Personalized E-Mail from Excel
This tip describes a method to compose and send short customized e-mail messages from Excel, using the HYPERLINK function.
About the HYPERLINK function
The HYPERLINK function creates a link that, when clicked, activates your default browser and navigates to a web page. The function takes two arguments: the URL and the text that’s displayed in the cell. For example, this formula creates a link to my website:
=HYPERLINK(“http://spreadsheetpage.com”,”Spreadsheet Page”)
A URL can also contain an e-mail address. When clicked, the hyperlink opens the new message window of your default e-mail client, with the e-mail address in the “To” field. Here’s an example:
=HYPERLINK(“mailto:[email protected]”,”Email support”)
If you don’t have a local default e-mail client and rely on a web-based e-mail service (such as Gmail...