Mail-merge problem

[sepia]

Presently, I'm producing docs in Word via mail-merge from a Access database. As of now, there is one record per page. I would like to display two records per page. I tried using the {next record} command which will work but the second record on the previous page is displayed as the first record on the following page. Would the {next record if} work? If so, how would it be used?

Thanks in advance.

 

[girlpower]

I had this same problem in one of my applications.

To create the merge document, create your template for only 1 page. On this single document, insert your merge fields. The trick is to size your document so that 2 will fit on a single page.

To do this, open Page Setup in Word. Click the check box next to "2 Pages per Sheet" and work with your margins until you get the right fit. Close Page Setup. On the Word document, click Merge and select "Merge to New Document" and click Merge. A new document will open that will have 2 pages per sheet.

Don't use Next Record. Try this sizing method and see if it works for you. Good luck.

 

[JPeters]

sepia,
If girlpower didnt answer your question, hop over to Microsoft: Office Forum (18723 members)
forum68

Those Microsoft Office guys are really good at Mail Merge. I got lots of help from them last summer when I was creating a DB of the same sort.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------