Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I place a merge data field in a specific location on a labe
I have created a custom label 3/4" x 1-5/8 in Word 2003.. I am using
mailmerge and I need to place three mergedata fields from an Excel spreadsheet on the bottom line of the label, irregardless of how many text lines appear before it. (The number of lines may vary.) I have tried the { ADVANCE \y xx } option, where xx is the offset to the last line in points, but it does not work. The { ADVANCE \x xx } option works as expected by offsetting the next field a fixed offset to the right on the label, so I think I am inserting the command field correctly. The one and only line of text on the label prints on the center line of the label no matter what offset I use with the ADVANCE command. Can anyone suggest what might be wrong? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I place a merge data field in a specific location on a labe
Unfortunately ADVANCE \y doesn't work in tables: Word 2003 Help says
"Microsoft Word ignores the \y switch if you specify a location outside the page margins or use the switch in tables, text boxes, footnotes, endnotes, annotations, headers, or footers." What I would do in this case is modify the table so that you can place your bottom line: for each table row: a. use Table|Split to create two rows. b. adjust the row heights using e.g. Table|Table Properties. c. (obviously) insert your "ordinary" fields in the upper cells, and your special field in the lower cells. Have a good look around Table Properties to make sure you are fixing row height etc. as necessary. After that, Propagate labels probably won't work how you might hope, so you can either Propagate labels and then clear out all the additional rubbish it inserts, or copy your fields and text manually, ensuring that there is a { NEXT } field (Next reocrd) at the top of each /label/ except the first. Peter Jamieson "BreezyKen" wrote in message ... I have created a custom label 3/4" x 1-5/8 in Word 2003.. I am using mailmerge and I need to place three mergedata fields from an Excel spreadsheet on the bottom line of the label, irregardless of how many text lines appear before it. (The number of lines may vary.) I have tried the { ADVANCE \y xx } option, where xx is the offset to the last line in points, but it does not work. The { ADVANCE \x xx } option works as expected by offsetting the next field a fixed offset to the right on the label, so I think I am inserting the command field correctly. The one and only line of text on the label prints on the center line of the label no matter what offset I use with the ADVANCE command. Can anyone suggest what might be wrong? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge data file location drops out of template when edited | Mailmerge | |||
mail merge default data source location | Mailmerge | |||
Maniplulating the data source location of a merge, MS Word merge | Mailmerge | |||
Save mail merge letters with a filename in a specific location Hel | Mailmerge | |||
merge field numbering/decimal place problem | Mailmerge |