Solved

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

Posted on 2014-01-29
1
610 Views
Last Modified: 2014-02-01
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
Comment
Question by:SteveL13
1 Comment
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
ID: 39821842
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 Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question