[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" wrote in message
...
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

[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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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

[jbc]

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

"jbc" wrote:

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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]

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

"jbc" wrote in message
news
The NextRecord in the first column is over column B. I wish i could
line
this up better for illustration.

"jbc" wrote:

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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