Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SendObject (Access03)

    How do I send multiple reports in one email? I don't want to combine the two reports into one, but they will usually go out together. I am using the following code for the basics, but havent' figured out how to combine to reports.

    Private Sub cmdEmailFuture_Click()
    On Error GoTo Err_cmdEmailFuture_Click

    Dim stDocName As String
    Dim stDocName1 As String
    stDocName = "rptFutureClasses"
    stDocName1 = "rptFutureRegistrations"
    DoCmd.SendObject acSendReport, stDocName, acFormatRTF, [Forms]![frmReports]![txtEndoManager] _
    , , , "Future classes and registrations", "Thank you. Please let me know if there are" _
    & " any problems. Fay"
    Exit_cmdEmailFuture_Click:
    Exit Sub

    Err_cmdEmailFuture_Click:
    MsgBox Err.Description
    Resume Exit_cmdEmailFuture_Click

    End Sub

    Thank Fay

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

    Re: SendObject (Access03)

    You can mail only one object (table, query, report) at a time with SendObject. There is no way to add multiple attachments. If you need that, you can use Automation to control Outlook from Access.

    See <post:=383,316>post 383,316</post:> for an example and WendellB's tutorial Automation 101 for general info on Automation.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject (Access03)

    Bummer. Thanks Hans I will check the other two items out. Fay

Posting Permissions

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