Worksheet.MailEnvelope Property (Excel)
Rrepresents an e-mail header for a document.
식 .MailEnvelope
식 A variable that represents a Worksheet object.
This example sets the comments for the header of the active worksheet.
Sub HeaderComments()
ActiveSheet.MailEnvelope.Introduction = "To Whom It May Concern: "
End Sub