Subject Property
Applies To
Mailer object, RoutingSlip object.
Description
Returns or sets the subject for the mailer or routing slip. Read/write String.
Remarks
The subject for the RoutingSlip object is used as the subject for mail messages used to route the workbook.
On the Macintosh, PowerTalk requires that there be a subject before the mailer can be sent.
See Also
Author property, Comments property, Delivery property, Message property, Recipients method, ReturnWhenDone property.
Example
This example sets the subject for a routing slip for the open workbook. To run this example, you must have Microsoft Exchange or Microsoft Mail for the Macintosh installed.
With ThisWorkbook
.HasRoutingSlip = True
With .RoutingSlip
.Delivery = xlOneAfterAnother
.Recipients = Array("Adam Bendel", "Jean Selva", "Bernard Gabor")
.Subject = "Here is the workbook"
.Message = "Here is the workbook. What do you think?"
.ReturnWhenDone = True
End With
.Route
End With
This example sets the subject for a mailer in the PowerTalk mail system (Macintosh only). To run this example, you must have the PowerTalk mail system installed.
With Workbooks(1)
.HasMailer = True
With .Mailer
.Subject = "Here is the workbook"
.ToRecipients = Array("Jean")
.CCRecipients = Array("Adam", "Bernard")
.BCCRecipients = Array("Chris")
.Enclosures = Array("TestFile")
End With
.SendMailer
End With