Results 1 to 8 of 8

Thread: Combine multiple reports into one for export, printing
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Combine multiple reports into one for export, printing

    I have several reports that I need to combine into one print out. I would like for them to merge into one big report so I can send them out in an email or print out as one file instead of printing each one seperately. Is there a way to combine these reports without making them into subreports? Thanks

  2. #2
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,103
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    Click macro under objects to choose multiple reports you want printed at once. I think you need the Adobe add-in to combine the reports as a PDF.

  3. #3
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    Thanks, yea I need the add in. I was hoping there was a way around that so I could combine a selection of reports into one print out or pdf document.

  4. #4
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,103
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    Were you able to combine the printouts using the macro object?

  5. #5
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    No, I don't have the add in for the pdf.

  6. #6
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,103
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    I mean sending them all to the printer in one click. Unless by "print out" you only meant to pdf.

  7. #7
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    Oh, I only meant to pdf. If I can print them all out at one time any other way that would be great. I am not following you on how to do that though. I thought the only way to print mulitple reports out was by utilizing pdf?

  8. #8
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,103
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine multiple reports into one for export, printing

    Well I currently have just Access 2003 on my pc, but I recall 2007 being similar. Under the objects list (Tables, Queries, Forms, Reports, Pages, Macros, Modules) choose Macros, then OpenReport from the drop down list. The default view should be Print (at least it is in 2003) otherwise select it.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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