Name Badges 2003

[jbc]

Hi,

I'm creating name badges from an Excel file. I'm using a name badge from
Avery (5390) with 8 badges per page.

I have 2 or 3 lines of text in the center of the badge and want the title to
always be in the same spot. I would like the person's title to be located in
the lower left hand corner of each badge. Is there a way to fix the field
onto a location? I tried a text box, but couldn't get it to lock.

Thanks.

jbc

 

[Doug Robbins - Word MVP]

Labels are just tables with fixed cell dimensions. To force something into
a position, you could split the cell that forms that label and adjust the
dimensions of the resulting cells and alignment of the paragraphs within
those cells so that you achieve the layout that you require.

See the article "Graphics on Labels" on fellow MVP Graham Mayor's website at

http://www.gmayor.com/graphics_on_labels.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[jbc]

I split the each cell into 2 rows. Now 2 rows make up one name badge.

First Label (Position A1) Second Label Position B1
-----------------------row 1-------------------------------------
«Next Record»
Organization Name Organization Name

«FirstNameCompany» «FirstNameCompany»
«NameAddress» «NameAddress»
------------------------row 2------------------------------------
«Title» «Title»

-----------------------row 3------------------------------------
«Next Record» «Next Record»
Organization Name Organization Name

«FirstNameCompany» «FirstNameCompany»
«NameAddress» «NameAddress»
------------------------row 4-----------------------------------
«Title» «Title»

continues to last row


I'm having a problem when the title field is blank. Word is chosing the
next person's title. Is there something wrong with my field placement of the
NextRecord? Why is Word treating the blanks like this? I don't have the
problem with this when I don't split the cell into 2 parts.

Thanks.

jbc

 

[jbc]

The <<NextRecord>> in the first column is over column B. I wish i could line
this up better for illustration.

 

[Doug Robbins - Word MVP]

The <<Next Record>> placement looks OK.

A way to prevent the problem may be to use an If...then...Else field
construction

{ IF { MERGEFIELD Title } <> "" "{ MERGEFIELD Title }" " " }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP