Solved: Mail Merge Help

[Opv]

I'm trying to set up a mail merge for name tag labels. I have set up the document, opened the database (Excel spreadsheet) and everything looks like it is set up correctly. There is no filter needed as all names in the database should be printed.

My problem is that when I view the mail merge document fields, it correctly shows the <NAME> field in the first block and the <NEXT RECORD> statement in all the other empty blocks. However, when I click to view the merged data, it is only displaying the name in the top left block and if I merge the data to a new document it is printing only one name per page.

I can't seem to find any option that addresses this problem. What do I need to change to tell WORD to print in all available spaces on each page of name tags?

Opv

P.S. This is WORD 2000.

[lucas]

I don't use mailmerge because it's so glitchy. See my post #7 in this thread for an alternative using bookmarks.

http://www.vbaexpress.com/forum/showthread.php?t=31565

[Opv]

I don't use mailmerge because it's so glitchy. See my post #7 in this thread for an alternative using bookmarks.

http://www.vbaexpress.com/forum/showthread.php?t=31565

Thanks, I responded in the other thread before realizing what I was doing. I couldn't get the zip file link in the other thread to work.

[Opv]

I figured out the problem. Apparently the subsequent labels need both <NAME> and <NEXT RECORD> to pull in the information. It's working properly now.

Thanks,

Opv