Solved

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

Posted on 2014-01-29
1
611 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

733 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