I realize this is a simple procedure compared to most of what is being dealt with on the forum. But I do need help with it.

I am attempting to make a roster from a database, basically a list. I'd love to have it in a table. I set up the database while in Publisher 2010, intending to use that. But was unable to get it to produce what I wanted. Then shifted gears and tried Word 2010. I can't get it there either.

Each time, I put all my field into my table as I want, and merge to print, preview expecting to have to print all on same page. However it asks me to tile them or single page view.

Then I tried the "Directory" creator portion of the mail merge, hoping it would allow a next record jump. I'm just not getting the right sequence in for this to work correctly.



Again, I realize this is so very simplistic for many of you, but I have not used this area in quite some time so am very rusty. Please help.

Did you click on 'Finish & Merge' after setting up your mailmerge main document? Your description suggests you're only viewing the mailmerge main document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yep, finished and merged. It will show me each individual record on a separate sheet, same as it will print. Will not print them consecutively on the page, one line under the other which is what I would like. As a list on a table.

Seems so simplistic, but is really being a bugger.

Thank you for asking, I knew there were parts of the document had forgotten to describe that people would need to know.

If you want multiple records per page, you need to use either a label merge or a directory/catalogue merge. With a label merge, you set up the mergefields for the first label, then click on the 'Update labels' button to propagate the structure to the other labels. For a plain directory/catalogue merge, you insert just the one set of mergefields; more complex directory/catalogue merges are also possible, with sorted records, using additional field coding.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]