[JayShoe]

Hello,

I'm trying to make a karaoke song book using an excel database I have along
with Microsoft Word 2002. I've successfully created a table with
Singer/Song/Id. The challenge that I have is that I would like to have a way
to avoid printing duplicate artist fields when multiple songs exist for that
particular artist.

For example, right now the table looks something like this:

Artist Title ID
Jackson Billy 5
Jackson P.Y.T. 6
Jackson Song 7

But instead, I'd like the system to "group" the artist (in this case
"jackson") so it looks like this:

Jackson
Billy 5
P.Y.T. 6
Song 7

Is there a way to do that?

Jay

[Graham Mayor]

How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source which you can download from my website
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



JayShoe wrote:
Hello,

I'm trying to make a karaoke song book using an excel database I have
along with Microsoft Word 2002. I've successfully created a table with
Singer/Song/Id. The challenge that I have is that I would like to
have a way to avoid printing duplicate artist fields when multiple
songs exist for that particular artist.

For example, right now the table looks something like this:

Artist Title ID
Jackson Billy 5
Jackson P.Y.T. 6
Jackson Song 7

But instead, I'd like the system to "group" the artist (in this case
"jackson") so it looks like this:

Jackson
Billy 5
P.Y.T. 6
Song 7

Is there a way to do that?

Jay