Solved

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

Posted on 2014-01-29
1
609 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

805 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