Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Word 2003 Mail Merge with Excel Spreadsheet Database

by got2byes Feb 13, 2009 4:33AM PST

Each of my records has a person from a school. Each school from 1 to 9 people, thus from 1 to 9 records. I can sort by school name and manually check all the people from one school but I would like to automate the selection.
I want to know how to create my master form so that I list each person from one school on one page, then automate the switch to a new list on a new page each time the school name changes.
For instance:
Page 1 is for School 1 and lists 7 people (7 records).
Page 2 is for School 2 and lists 3 people (3 records)...
The criteria that signals the page change is the school change.

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

That's not easy, alas.

by Kees Bakker Feb 13, 2009 6:58AM PST

Personally, I use an MS Access report to do this. Reporting programs like that are quite good in handling level breaks. That's what they are designed for, more or less.

http://www.eggheadcafe.com/software/aspnet/31981448/need-merge-field-content.aspx might help. I found the link to http://support.microsoft.com/default.aspx?scid=kb;en-us;211303 quite helpful.

But, as I said, it isn't easy. Let's say it's advanced usage of Word.

Kees

Back to Windows Legacy OS forum