If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Name Badges 2003
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 |
#2
|
|||
|
|||
Name Badges 2003
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 |
#3
|
|||
|
|||
Name Badges 2003
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 |
#4
|
|||
|
|||
Name Badges 2003
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 |
#5
|
|||
|
|||
Name Badges 2003
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 |
Thread Tools | |
Display Modes | |
|
|