Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Group email a report (2003 SP2)

    I want to send group emails of a report, but I can
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Group email a report (2003 SP2)

    DoCmd.SendObject acSendReport, "rptMyReport", acFormatRPT, You@Somewhere.com

    is not correct: the To argument should be a string. This string can contain several recipients, separated by semicolons:

    DoCmd.SendObject acSendReport, "rptMyReport", acFormatRPT, "You@Somewhere.com;Him@Elsewhere.com;Her@Yetanothe r.com"

    Similar for the Cc and Bcc arguments. You can, of course, assemble these strings using code.

    If you search this forum for recipients.add you'll find several examples of adding multiple recipients to an e-mail using Outlook Automation.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group email a report (2003 SP2)

    Many thanks Hans (again)
    Regards,
    Peter

Posting Permissions

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