Merge 2 reports in a PDF and email from Access 20130

[Kathryn]

I am new to Access
I created two reports and a Main Menu which will allow a user to select a specific account number and generate two separate reports.
Want to merge the two reports together in a PDF and email that merger to a specific user.

How can a accomplish this task?
Thank you

[ItsMe]

I have a special function that relies on a DLL file I purchased. I can append and format PDF files with this. Not sure if newer versions of Access will allow an append option with acFormatPDF.

The best approach is probably to merge the two reports before you export to PDF. You may get what you are after by creating a subreport.

[amrut]

Read on this forum, not tried it
https://www.accessforums.net/access/...pdf-25574.html

[ItsMe]

Read on this forum, not tried it
https://www.accessforums.net/access/...pdf-25574.html

That's cool. I have seen this before, but this example looks real clean. I am going to implement this in an app this weekend.

I guess it could break if you update Adobe to a new version and the reference to the earlier version loses its support files. Disabling Adobe updates at all of the clients can be a real chore.

[Kathryn]

Thank you, everyone, for your responses.
The subreport does not work correctly becauase I have two separate footers. When I created the subreport it added the 2nd report to the bottom of every page of the 1st report and divided the 1st report into multiple pages.
I will see if the VBA response will work.


Thanks

[ItsMe]

I am getting an Active X error with the VBA June7 posted in the link. I am going over references now. Couldn't wait for the weekend.

[ItsMe]

Now I remember why I purchased the DLL file.

You can't create AcroExch. objects with reader. I may be missing something. But I think this is the reality. You need Adobe Acrobat installed on the OS.

[Kathryn]

I will confirm that we have Adobe Arcobat installed on that server. Going to try that VBA now.
My goal is to eventally move the database to SharePoint Online and complete this task through sharepoint.

Thanks