How to print merge records on one page

N

newday

I am using Word 2002/Excel to create a directory of students. Instead of
printing one list -- it prints each student on a separate page. PLEASE help.
 
D

Doug Robbins - Word MVP

Are you using a Directory type mailmerge main document? Sounds more like
you are using a Formletter type main document. With a Directory type main
document, arrange one set of the merge fields in the configuration that you
want them and then execute the merge to a new document, which is the only
possible destination.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
N

newday

I am using Directory as my document type. The only thing I can figure is the
form I'm using may have some kind of "codes" in it that is skipping each
record to the next page.

I am using a form that has columns for name / address / phone # / etc & then
has lines for you to fill in the information. I don't know how to see what
sort of formatting is in this form I'm trying to merge into.

Thanks . . . I do appreciate your help.
 
D

Doug Robbins - Word MVP

In the main document, insert a one row table into the cells of which you
insert the merge fields. There should be nothing else in the main body of
that document. Then, when you execute the merge, the table in the document
that is created will contain a row of data for each record in the data
source. If there is other information that you want in the merged document,
such as column headings, they will need to be inserted into the document
produced by the merge, rather than into the main document itself, though
another way is the have the column headings as the first record in the data
source and then set the heading row repeat item from the tables menu after
executing the merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
N

newday

Thank you so much!! I had way too much stuff going inside my main document.
When I cleared it out & put in the one line table -- it worked!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top