Subject Property

Microsoft Excel Visual Basic

Subject Property

       

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.

Example

This example sets the subject for a routing slip for the open workbook. To run this example, you must have Microsoft Exchange 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