• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

How insert a Word mail merge document on page two of a report

I have a 1 page report and I want to insert a page break and have a Word mail merge document appear on page 2.

Can this be done?

--Steve
0
SteveL13
Asked:
SteveL13
1 Solution
 
Nick67Commented:
In theory, maybe.

But a mail merge document usually requires some user input about which record is going to be the one displayed.

And the fidelity and looks of an inserted Word document will probably be questionable.

I wouldn't pursue embedding the Word document as a solution for myself.  I would look at eliminating Word altogether and doing everything as an Access report, or at automating Word from Access VBA code (opening the merge doc, pointing it a the recordsource and selecting the required record(s) and issuing a print command.

Because the Access report has margins and the OLE control the merge doc would be embedded in has a finite size it is very hard to get a seamless look and cover all the possibilities.

That's my 2 cents, anyway
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now