Name Badge Problems

Name Badge Problems - Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbc - 17 Oct 2007 01:16 GMT

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

Reply to this Message

Graham Mayor - 17 Oct 2007 06:02 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Hi, I'm trying to create name badges with data from Excel 2003. I'm
> using Avery 5390 8 up name badges.
[quoted text clipped - 49 lines]
>
> jbc

Reply to this Message

jbc - 17 Oct 2007 20:03 GMT

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

> Use a conditional field to ensure there is always something in place for
> title eg
[quoted text clipped - 56 lines]
> >
> > jbc

Reply to this Message

Graham Mayor - 18 Oct 2007 06:49 GMT

I don't know why you are making things difficult for yourself by splitting
the cells. Put it all in one cell. You can use conditional fields to insert
missing lines when fields may be empty eg

{IF {Mergefield Company} = "" "
"}{IF {Mergefield Street2} = "" "
"}etc

Immediately after the last address field (and on the same line) and before
the line you wish to remain constant placed, so every address will always
have the same number of lines and your last line will always be properly
placed.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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
[quoted text clipped - 74 lines]
>>>
>>> jbc

Reply to this Message