Hi Graham, Thank you for your suggestion. It doesn't work. The only way
I'm able to get it to work is if I put all of the fields into one cell. When
I split the individual name badges into 2 cells and tried to put the title in
the bottom cell, that's when the problems started.
I'm not sure if this is part of it. My data is coming from Excel.
jbc
"Graham Mayor" wrote:
Use a conditional field to ensure there is always something in place for
title eg
{IF {Mergefield Title} "" "{Mergefield Title}" " " }
which inserts a few spaces when there is no title.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
jbc wrote:
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