[jbc]

Hi, I'm trying to create name badges with data from Excel 2003. I'm using
Avery 5390 8 up name badges.

I want the labels to look like this:
_____________________
Name of organization

First Name
Company (Most don't have company)
Full Name, City, State

Instructor/Vendor/etc. (Field name Title)
___________________________


I want Instructor/Vendor/etc. to appear in the same spot on every badge.
The number of hard returns will vary if there is no company listed.

I split each label into 2 so that the information will always be in the same
spot and am having trouble. The merge is not working correctly when there is
no title. Word is pulling from the next record.


Label 1 --------------------------------------------Label 2

********************************************
--------------------------------------------------Next Record
org name---------------------------------------org name

FirstName--------------------------------------FirstName
Company---------------------------------------Company

______________________________________________

Title--------------------------------------------Title

************************************************
Label 3---------------------------------------------Label 4
NextRecord---------------------------------Next Record
org name---------------------------------------org name

FirstName--------------------------------------FirstName
Company---------------------------------------Company

______________________________________________

Title--------------------------------------------Title

Same until 8th Label

Thank you.

jbc