BCCRecipients Property

Applies To

Mailer object.

Description

Returns or sets the recipients of a blind carbon copy of the mailer. Available only in Microsoft Excel for the Macintosh, with the PowerTalk mail system extension installed. Read/write Variant.

Remarks

This property uses an array of strings specifying the address of each recipient, in one of the following formats:

A record in the Preferred Personal Catalog. These names are one level deep ("Fred" or "June," for example).
A full path specifying either a record in a personal catalog ("HD:Excel Folder:My Catalog:Barney") or a plain record ("HD:Folder:Martin").
A relative path from the current working folder specifying either a personal catalog record ("My Catalog:Barney") or a plain record ("Martin").
A path in a PowerShare catalog tree, in the form "CATALOG_NAME:<node>:RECORD_NAME", where <node> is a path to a PowerShare catalog. An example of a complete path is "AppleTalk:North Building Zone:George's Mac".

See Also

CCRecipients property, Enclosures property, Mailer property, Received property, SendDateTime property, Sender property, SendMailer method, Subject property, ToRecipients property.

Example

This example sets up the Mailer object for workbook one and then sends the workbook.

With Workbooks(1)
    .HasMailer = True
    With .Mailer
        .Subject = "Here is the workbook"
        .ToRecipients = Array("Jean")
        .CCRecipients = Array("Adam", "Bernard")
        .BCCRecipients = Array("Chris")
        .Enclosures = Array("TestFile")
    End With
    .SendMailer
End With