Hyperlink.EmailSubject Property (Excel)
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.
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.