Recipients Method

Applies To

RoutingSlip object.

Description

Returns or sets the recipients on the routing slip.

Syntax

expression.Recipients(Index)

expression Required. An expression that returns a RoutingSlip object.

Index Optional Variant. The recipient. If this argument isn't specified, the method 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.

See Also

Delivery property, Message property, ReturnWhenDone property, Subject property.

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