Microsoft Office Tutorials and References
In Depth Information
A practical example using HYPERLINK
B6: The body text, encoded using this formula:
=ENCODEURL(B5)
B7: The first argument for the HYPERLINK function, constructed by concatenating text and
cells. The formula is
=”mailto:”&B2&”?subject=”&(B4)&”&body=”&B6&””
B8: This cell contains a formula that uses the HYPERLINK function:
=HYPERLINK(B7,”Click to send”)
The length of the text in cell B7 (the first argument for the HYPERLINK function) cannot
exceed 255 characters. If the text is too long, cell B8 displays a #VALUE error.
Note
Figure 33-2 shows how it looks when Windows Live Mail is the default e-mail client.
Figure 33-2: This e-mail message was composed by the HYPERLINK function.
Search JabSto ::




Custom Search