Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2008

Tip: Looking for answers? Try searching our database.

Mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Terri - 14 Jan 2008 15:19 GMT
I want to merge an access file with word and have more than one record on a
page of paper.  How do I get word to put more than one record on a page
without pulling a new piece of paper.
Signature

Terri

Graham Mayor - 14 Jan 2008 15:44 GMT
Set the merge document type to directory/catalog.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I want to merge an access file with word and have more than one
> record on a page of paper.  How do I get word to put more than one
> record on a page without pulling a new piece of paper.
Peter Jamieson - 14 Jan 2008 15:58 GMT
There are two ways:
a. set up your merge to be a "Directory merge" (or "Catalog Merge" if you
are using Word 2000 or earlier, or starting from Outlook). In this case,
Word outputs record 2 immediately after record 1, with no page breaks, and
so on.
b. Edit|Copy whatever fields and text you have in your mail merge main
document, and edit|paste at the end of your document. Then insert a { NEXT }
field before the stuff you just pasted in (e.g. press ctrl-F9 to give you a
pair of the special field braces { }, then type NEXT in between, so you have

{ NEXT }

Option (a) is probably simpler if you just want as many records as you can
get on each page.
Option (b) is probably the way to go if you want a specific number of
records on each page and/or you want different information printed for each
record.

Neither of these will let you do a "multiple records per condition" merge,
where (for example) you have an invoive header, followed by a number of
invoice detail records, then another header and so on.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I want to merge an access file with word and have more than one record on a
> page of paper.  How do I get word to put more than one record on a page
> without pulling a new piece of paper.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.