Hyperlink.EmailSubject Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

expression .EmailSubject

expression A variable that represents a Hyperlink object.

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.

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

Worksheets(1).Hyperlinks(1).EmailSubject = "Quote Request"