Hyperlink.EmailSubject Property

Excel Developer Reference

Returns or sets the text string of the specified hyperlink’s e-mail subject line. The subject line is appended to the hyperlink’s address. Read/write String.

Syntax

expression.EmailSubject

expression   A variable that represents a Hyperlink object.

Remarks

This property is usually used with e-mail hyperlinks.

The value of this property takes precedence over any e-mail subject line you have specified by using the Address property of the same Hyperlink object.

Example

This example sets the e-mail subject line for the first hyperlink in the first worksheet.

Visual Basic for Applications
  Worksheets(1).Hyperlinks(1).EmailSubject = "Quote Request"

See Also