Mail Merge

**Ethan Gingras** · Aug 26 '10, 07:49 PM

Consider the following table:

Code:

Supervisor  Employee
Jane        Bob
Jane        Pete
Jane        Jenny
John        Cliff
John        Andrew
Charles     Robbie
Edward      Zed
Edward      Philip

I need to create one Word document for each unique Supervisor, and one page in that document for each Employee for that Supervisor.

So in the above example, I would need the following documents:
Jane.doc
Page 1 - Bob
Page 2 - Pete
Page 3 - Jenny

John.doc
Page 1 - Cliff
Page 2 - Andrew

Charles.doc
Page 1 - Robbie

Edward.doc
Page 1 - Zed
Page 2 - Philip

What's the quickest way to create these documents using a Mail Merge?