Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Cc and Bcc in DoCmd.SendObject (2002 SP-2)

    Is it possible to include the Cc: and Bcc: attributes of an e-mail in the following (partial) code?
    This is a DoCmd.SendObject (sends report to Outlook distribution list). I do not want to reveal all the names in the list to the recipients.

    <pre>Private Sub CmdLoadsAvailable_Click()
    On Error GoTo ErrHandler
    'Email rptLoadsAvailable to AAACarriersAll (Outlook)

    Dim strReportName As String
    Dim strRecipient As String
    Dim strSubject As String
    Dim strMessage As String
    Dim blnEditMail As Boolean

    strReportName = "rptLoadsAvailable"
    strRecipient = "AAACarriersAll"
    strSubject = "Available Loads"
    strMessage = "The attached Available Loads Report </pre>



    I tried:
    Dim strBcc As String
    - - - - -
    strBcc = "AAACarriersAll"
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Cc and Bcc in DoCmd.SendObject (2002 SP-2)

    Yes. Here are the arguments accepted by Send Object

    DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage]
    Regards
    John



  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Cc and Bcc in DoCmd.SendObject (2002 SP-2)

    Thanks John!

    I had them defined correctly, but <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> forgot to include them in the DoCmd.
    I also learned the importance of where the " , " go. (Bcc ended up in the subject line)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •