G
Glenn Hoetker
Hoping someone can help me with a data merge issue. I have Office
2004. Essentially, I'm making class rosters. My data (stored in an
Excel sheet) looks something like this
CLASS NAME Some other data fields
Basketball Earvin Johnson
Basketball Larry Bird
Basketball Michael Jordan
Tennis John McEnroe
Tennis Jimmy Conners
I want to produce a merged word document that looks like this
Basketball
Earvin Johnson Other data fields....
Larry Bird
Michael Jordon
-------New page-------
Tennis
John McEnroe Other data fields
Jimmy Conners
I'm not too picky about the exact formating. I don't care if it has to
look like
Tennis John McEnroe
Tennis Jimmy Conners
just so long as each class comes on its own page. I have about 15
different classes and I'd like to keep this general enough that no
changes are required as classes are added/dropped.
Can anyone help me out on this? It seems like the NEXTIF field would
be key, but I've experimented and read documentation and can't get it
to work.
Thanks in advance!
2004. Essentially, I'm making class rosters. My data (stored in an
Excel sheet) looks something like this
CLASS NAME Some other data fields
Basketball Earvin Johnson
Basketball Larry Bird
Basketball Michael Jordan
Tennis John McEnroe
Tennis Jimmy Conners
I want to produce a merged word document that looks like this
Basketball
Earvin Johnson Other data fields....
Larry Bird
Michael Jordon
-------New page-------
Tennis
John McEnroe Other data fields
Jimmy Conners
I'm not too picky about the exact formating. I don't care if it has to
look like
Tennis John McEnroe
Tennis Jimmy Conners
just so long as each class comes on its own page. I have about 15
different classes and I'd like to keep this general enough that no
changes are required as classes are added/dropped.
Can anyone help me out on this? It seems like the NEXTIF field would
be key, but I've experimented and read documentation and can't get it
to work.
Thanks in advance!