Name Badge Problems - Word 2003
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
|