Share via

RoutingSlip.Message Property

  • Article
Excel Developer Reference

Returns or sets the message text for the routing slip. This text is used as the body text of mail messages that are used to route the workbook. Read/write String.

Syntax

expression.Message

expression   A variable that represents a RoutingSlip object.

Example

This example sends Book1.xls to three recipients, one after another.

Visual Basic for Applications 
  Workbooks("BOOK1.XLS").HasRoutingSlip = True
With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Adam Bendel", _
        "Jean Selva", "Bernard Gabor")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
End With
Workbooks("BOOK1.XLS").Route

See Also