RoutingSlip.Recipients Property

  • Article
Excel Developer Reference

Returns or sets the recipients on the routing slip.

Syntax

expression.Recipients(Index)

expression   A variable that represents a RoutingSlip object.

Parameters

Name Required/Optional Data Type Description
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.

Visual Basic for Applications 
  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

See Also