Microsoft Office Tutorials and References
In Depth Information
A practical example using HYPERLINK
A practical example using HYPERLINK
Figure 33-1 shows a worksheet set up to make it easy to send a brief personalized e-mail from Excel.
Figure 33-1: The hyperlink in cell B8, when clicked, opens the default e-mail client with a message ready
to send.
Here’s a description of each cell:
B1: The first name of the e-mail recipient.
B2: The e-mail address.
B3: The subject line for the e-mail address.
B4: The subject line, encoded using this formula:
=ENCODEURL(B3)
B5: The body of the message. This cell uses wrap text formatting, and line breaks were
entered by using Alt+Enter.
Search JabSto ::




Custom Search