Recipients Property

Microsoft Excel Visual Basic

Returns or sets the recipients on the routing slip.

expression.Recipients(Index)

expression    Required. An expression that returns a RoutingSlip object.

Index    Optional Variant. The recipient. If this argument isn’t specified, the Recipients property returns (or can be set to) an array that contains all recipients.

Remarks

The order of the recipient list defines the delivery order if the routing delivery option is xlOneAfterAnother.

If a routing slip is in progress, only those recipients who haven’t already received and routed the document are returned or set.

Example

This example sends the open workbook to three recipients, one after the other.

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