BCCRecipients Property

Applies To

Mailer Object.

Description

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

Remarks

This property is an array of strings specifying the address, in one of the following formats:

• A record in the Preferred Personal Catalog. These names are one level deep ("Fred" or "June").
• 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 of 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