Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
W2K: labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
I absolutely must have cell margins that are at about 0.05" around the
insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
Leave labels alone and achieve the space that you are after by changing the
formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
Okay, however non-intuitive this solution would be, it is doing the job,
thank goodness. I'm still having one problem. I'm getting an extra row at the bottom of the merged end document. The original target document has the correct spacing at the bottom, but the merged doct. puts in an extra row. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? Pls advise. D "Doug Robbins - Word MVP" wrote in message ... Leave labels alone and achieve the space that you are after by changing the formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
Can you spell this out a bit? I read and re-read, but wasn't sure what
exactly you are seeing. Is the extra row at the very end of the output, and what exactly does it contain (a duplicate of the last row of labels?) In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? In Word 2000, the main thing to get right is "no { NEXT } field in the first label cell on the sheet, one { NEXT } field at the beginning of each label cell after that", bearing in mind that some cells in some layouts - such as 5167 - have "spacer" columns of cells that should not have anything in them. Peter Jamieson "StargateFanFromWork" wrote in message ... Okay, however non-intuitive this solution would be, it is doing the job, thank goodness. I'm still having one problem. I'm getting an extra row at the bottom of the merged end document. The original target document has the correct spacing at the bottom, but the merged doct. puts in an extra row. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? Pls advise. D "Doug Robbins - Word MVP" wrote in message ... Leave labels alone and achieve the space that you are after by changing the formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
"Peter Jamieson" wrote in message
... Can you spell this out a bit? I read and re-read, but wasn't sure what exactly you are seeing. Is the extra row at the very end of the output, and what exactly does it contain (a duplicate of the last row of labels?) Yes, certainly. And thanks for the question; it helped to look at this from a different angles to try to figure out what's wrong. Admittedly, I've not done many mail merges in Word. All that I used to do in my years as a word-processor when WP was the standard. I hadn't actually looked at the data, so hadn't realized that I was just getting one record repeated over and over g. My extensive WP experience helped out and I remembered that there, too, we had to put and "End Record" field in. Once I did that, this Word mail merge worked properly in that way, too. So here's the problem. 5167 has 4 columns of 20 rows (for a total of 80 labels). The original target label file has the standard 8x20. But the merged docts all come out at 8x21! I don't know how to fix this. I just thought of this, here's what in each cell in the original target label file: User: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PNNext Record I bet you that this will make much clearer what I'm doing wrong. Each and every cell has the above coding but I'm not sure if this is completely right. Perhaps I'm missing something here, too, that is generating labels with an incorrect # of rows. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? In Word 2000, the main thing to get right is "no { NEXT } field in the first label cell on the sheet, one { NEXT } field at the beginning of each label cell after that", bearing in mind that some cells in some layouts - such as 5167 - have "spacer" columns of cells that should not have anything in them. I might have misunderstood the above paragraph, but when I removed the "Next Record" (doesn't show up as "{ NEXT }" for me. I'm using an Excel file that I used to put in the fields, btw), in the first cell, the first 2 cells in the merged label output were repeated. So that's not what you're referring to, obviously g. Re the spacer columns, yes. There is nothing in those columns at all and they remain empty after the merge. So okay there. Is it possible to tell what I'm doing wrong judging from the coding above?? Thanks. D Peter Jamieson "StargateFanFromWork" wrote in message ... Okay, however non-intuitive this solution would be, it is doing the job, thank goodness. I'm still having one problem. I'm getting an extra row at the bottom of the merged end document. The original target document has the correct spacing at the bottom, but the merged doct. puts in an extra row. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? Pls advise. D "Doug Robbins - Word MVP" wrote in message ... Leave labels alone and achieve the space that you are after by changing the formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
Check that in the FilePrint dialog, the Scale to paper size option is set
to "No scaling" -- 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 "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... Can you spell this out a bit? I read and re-read, but wasn't sure what exactly you are seeing. Is the extra row at the very end of the output, and what exactly does it contain (a duplicate of the last row of labels?) Yes, certainly. And thanks for the question; it helped to look at this from a different angles to try to figure out what's wrong. Admittedly, I've not done many mail merges in Word. All that I used to do in my years as a word-processor when WP was the standard. I hadn't actually looked at the data, so hadn't realized that I was just getting one record repeated over and over g. My extensive WP experience helped out and I remembered that there, too, we had to put and "End Record" field in. Once I did that, this Word mail merge worked properly in that way, too. So here's the problem. 5167 has 4 columns of 20 rows (for a total of 80 labels). The original target label file has the standard 8x20. But the merged docts all come out at 8x21! I don't know how to fix this. I just thought of this, here's what in each cell in the original target label file: User: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PNNext Record I bet you that this will make much clearer what I'm doing wrong. Each and every cell has the above coding but I'm not sure if this is completely right. Perhaps I'm missing something here, too, that is generating labels with an incorrect # of rows. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? In Word 2000, the main thing to get right is "no { NEXT } field in the first label cell on the sheet, one { NEXT } field at the beginning of each label cell after that", bearing in mind that some cells in some layouts - such as 5167 - have "spacer" columns of cells that should not have anything in them. I might have misunderstood the above paragraph, but when I removed the "Next Record" (doesn't show up as "{ NEXT }" for me. I'm using an Excel file that I used to put in the fields, btw), in the first cell, the first 2 cells in the merged label output were repeated. So that's not what you're referring to, obviously g. Re the spacer columns, yes. There is nothing in those columns at all and they remain empty after the merge. So okay there. Is it possible to tell what I'm doing wrong judging from the coding above?? Thanks. D Peter Jamieson "StargateFanFromWork" wrote in message ... Okay, however non-intuitive this solution would be, it is doing the job, thank goodness. I'm still having one problem. I'm getting an extra row at the bottom of the merged end document. The original target document has the correct spacing at the bottom, but the merged doct. puts in an extra row. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? Pls advise. D "Doug Robbins - Word MVP" wrote in message ... Leave labels alone and achieve the space that you are after by changing the formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
So here's the problem. 5167 has 4 columns of 20 rows (for a total of 80
labels). The original target label file has the standard 8x20. But the merged docts all come out at 8x21! I don't know how to fix this. The layout I get when I choose the 5167 option is 4x20. My best guess is that at some point along the way, you may have selected a table row and duplicated it by accident to make a 4x21 layout. To see what's happening, it may help to show the table gridlines - try Table|Gridlines. User: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PNNext Record Some Word-oriented terminology: a. Mail Merge Main Document: the layout (or "template", but that does not necessarily mean a Word .dot template) - i.e. how you want your output to look, and where to put each item of data b. Mail Merge Data Source - the data you are going to merge into the Mail Merge Main Document c. Mail Merge Destination - could be a Destination Document or a Destination Printer, etc. In the Mail Merge Main Document, the first label cell should have: User: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PN Subsequent label cells should have something like: Next RecordUser: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PN Peter Jamieson "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... Can you spell this out a bit? I read and re-read, but wasn't sure what exactly you are seeing. Is the extra row at the very end of the output, and what exactly does it contain (a duplicate of the last row of labels?) Yes, certainly. And thanks for the question; it helped to look at this from a different angles to try to figure out what's wrong. Admittedly, I've not done many mail merges in Word. All that I used to do in my years as a word-processor when WP was the standard. I hadn't actually looked at the data, so hadn't realized that I was just getting one record repeated over and over g. My extensive WP experience helped out and I remembered that there, too, we had to put and "End Record" field in. Once I did that, this Word mail merge worked properly in that way, too. So here's the problem. 5167 has 4 columns of 20 rows (for a total of 80 labels). The original target label file has the standard 8x20. But the merged docts all come out at 8x21! I don't know how to fix this. I just thought of this, here's what in each cell in the original target label file: User: USER UIN: UIN Country: COUNTRY S/N: SN Model: Model P/N: PNNext Record I bet you that this will make much clearer what I'm doing wrong. Each and every cell has the above coding but I'm not sure if this is completely right. Perhaps I'm missing something here, too, that is generating labels with an incorrect # of rows. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? In Word 2000, the main thing to get right is "no { NEXT } field in the first label cell on the sheet, one { NEXT } field at the beginning of each label cell after that", bearing in mind that some cells in some layouts - such as 5167 - have "spacer" columns of cells that should not have anything in them. I might have misunderstood the above paragraph, but when I removed the "Next Record" (doesn't show up as "{ NEXT }" for me. I'm using an Excel file that I used to put in the fields, btw), in the first cell, the first 2 cells in the merged label output were repeated. So that's not what you're referring to, obviously g. Re the spacer columns, yes. There is nothing in those columns at all and they remain empty after the merge. So okay there. Is it possible to tell what I'm doing wrong judging from the coding above?? Thanks. D Peter Jamieson "StargateFanFromWork" wrote in message ... Okay, however non-intuitive this solution would be, it is doing the job, thank goodness. I'm still having one problem. I'm getting an extra row at the bottom of the merged end document. The original target document has the correct spacing at the bottom, but the merged doct. puts in an extra row. In WP, I vaguely remember that the last field on the page needed an extra code (next record, or end record, or somesuch). Is this the same for Word? Pls advise. D "Doug Robbins - Word MVP" wrote in message ... Leave labels alone and achieve the space that you are after by changing the formatting of paragraphs - Left and Right Indent, Space Before and Space After. -- 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 "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
As far as I can tell, when you adjust the cell margin, Word actually
modifies the cell size (or at least, the height - I haven't even considered the width). It wouldn't surprise me to learn that this is a well-known "feature". I had to switch to using points as my measurement unit to see the changes with any precision, but with this label layout, before changing the cell margins, the first line of text in the first row was at 36pt according to the display in the status bar, and and the first line of the second row was at 72pt. After changing the cell margins to 0.05in, the equivalent values were 39.6pt and 79pt, and the cells were pushed over to the next page. Selecting the table and changing the row height to 32.4pt to compensate was enought to get all the labels back on one page, but whether it's what you need is another question. Peter Jamieson "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
"Peter Jamieson" wrote in message
... As far as I can tell, when you adjust the cell margin, Word actually modifies the cell size (or at least, the height - I haven't even considered the width). It wouldn't surprise me to learn that this is a well-known "feature". I had to switch to using points as my measurement unit to see the changes with any precision, but with this label layout, before changing the cell margins, the first line of text in the first row was at 36pt according to the display in the status bar, and and the first line of the second row was at 72pt. After changing the cell margins to 0.05in, the equivalent values were 39.6pt and 79pt, and the cells were pushed over to the next page. Selecting the table and changing the row height to 32.4pt to compensate was enought to get all the labels back on one page, but whether it's what you need is another question. Peter Jamieson Interesting, thank you! I"ll definitely take a look at this. Doug's recommendation involving changing spacing to the left and right of, and before and after paragraphs _seems_ to be working so far. Though this not something one would intuitively think of as as a solution (who would ever think of a cell in terms of a paragraph?), I'm just glad that something works. But I'll check into your solution above. I always learn something new when I try out a new technique. Thanks. D "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
IMO if it works, stick with it.
Something I noticed when experimenting with this was that the Word display was quite unstable when I modified the cell margins - i.e. it seemed to be updating continually. That could be just a problem with the display drivers, especially I as use a virtual machine to go back to the older versions of Word,, but it could also be a sign that the feature (or its implementation) requires a lot of processing. Peter Jamieson "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... As far as I can tell, when you adjust the cell margin, Word actually modifies the cell size (or at least, the height - I haven't even considered the width). It wouldn't surprise me to learn that this is a well-known "feature". I had to switch to using points as my measurement unit to see the changes with any precision, but with this label layout, before changing the cell margins, the first line of text in the first row was at 36pt according to the display in the status bar, and and the first line of the second row was at 72pt. After changing the cell margins to 0.05in, the equivalent values were 39.6pt and 79pt, and the cells were pushed over to the next page. Selecting the table and changing the row height to 32.4pt to compensate was enought to get all the labels back on one page, but whether it's what you need is another question. Peter Jamieson Interesting, thank you! I"ll definitely take a look at this. Doug's recommendation involving changing spacing to the left and right of, and before and after paragraphs _seems_ to be working so far. Though this not something one would intuitively think of as as a solution (who would ever think of a cell in terms of a paragraph?), I'm just glad that something works. But I'll check into your solution above. I always learn something new when I try out a new technique. Thanks. D "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
"Peter Jamieson" wrote in message
... IMO if it works, stick with it. True lol. But it's good to have a reserve solution for when the first one ends up not working at some point. I experimented with the paragraph spacing, btw, in a new Word table doct. I happened to be creating and the paragraph spacing didn't work there (case in point). Fortunately, cell margin editing could be done in that case since it was not a merge doct. with a small tricky label, etc. Anyway, it's always good to have more than one way of doing something. Something I noticed when experimenting with this was that the Word display was quite unstable when I modified the cell margins - i.e. it seemed to be updating continually. That could be just a problem with the display drivers, especially I as use a virtual machine to go back to the older versions of Word,, but it could also be a sign that the feature (or its implementation) requires a lot of processing. That's what that slight flickering must have been ... ! I couldn't figure out what that was though it was so slight that I thought it might be my system having too much to process at once besides Word. Anyway, thanks. Close to fixing this, there's just the issue of the extra row (as per the other message in this thread). Cheers. D Peter Jamieson "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... As far as I can tell, when you adjust the cell margin, Word actually modifies the cell size (or at least, the height - I haven't even considered the width). It wouldn't surprise me to learn that this is a well-known "feature". I had to switch to using points as my measurement unit to see the changes with any precision, but with this label layout, before changing the cell margins, the first line of text in the first row was at 36pt according to the display in the status bar, and and the first line of the second row was at 72pt. After changing the cell margins to 0.05in, the equivalent values were 39.6pt and 79pt, and the cells were pushed over to the next page. Selecting the table and changing the row height to 32.4pt to compensate was enought to get all the labels back on one page, but whether it's what you need is another question. Peter Jamieson Interesting, thank you! I"ll definitely take a look at this. Doug's recommendation involving changing spacing to the left and right of, and before and after paragraphs _seems_ to be working so far. Though this not something one would intuitively think of as as a solution (who would ever think of a cell in terms of a paragraph?), I'm just glad that something works. But I'll check into your solution above. I always learn something new when I try out a new technique. Thanks. D "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
labels thrown "out of whack" when cell or table margins changed? How to fix ... ?
True lol. But it's good to have a reserve solution for when the first
one ends up not working at some point. I agree. Typically it depends on whether you're doing a one-off (you just need to get it done) or are trying to get your infrastructure right for multiple-easy-to-use repeats. Peter Jamieson "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... IMO if it works, stick with it. True lol. But it's good to have a reserve solution for when the first one ends up not working at some point. I experimented with the paragraph spacing, btw, in a new Word table doct. I happened to be creating and the paragraph spacing didn't work there (case in point). Fortunately, cell margin editing could be done in that case since it was not a merge doct. with a small tricky label, etc. Anyway, it's always good to have more than one way of doing something. Something I noticed when experimenting with this was that the Word display was quite unstable when I modified the cell margins - i.e. it seemed to be updating continually. That could be just a problem with the display drivers, especially I as use a virtual machine to go back to the older versions of Word,, but it could also be a sign that the feature (or its implementation) requires a lot of processing. That's what that slight flickering must have been ... ! I couldn't figure out what that was though it was so slight that I thought it might be my system having too much to process at once besides Word. Anyway, thanks. Close to fixing this, there's just the issue of the extra row (as per the other message in this thread). Cheers. D Peter Jamieson "StargateFanFromWork" wrote in message ... "Peter Jamieson" wrote in message ... As far as I can tell, when you adjust the cell margin, Word actually modifies the cell size (or at least, the height - I haven't even considered the width). It wouldn't surprise me to learn that this is a well-known "feature". I had to switch to using points as my measurement unit to see the changes with any precision, but with this label layout, before changing the cell margins, the first line of text in the first row was at 36pt according to the display in the status bar, and and the first line of the second row was at 72pt. After changing the cell margins to 0.05in, the equivalent values were 39.6pt and 79pt, and the cells were pushed over to the next page. Selecting the table and changing the row height to 32.4pt to compensate was enought to get all the labels back on one page, but whether it's what you need is another question. Peter Jamieson Interesting, thank you! I"ll definitely take a look at this. Doug's recommendation involving changing spacing to the left and right of, and before and after paragraphs _seems_ to be working so far. Though this not something one would intuitively think of as as a solution (who would ever think of a cell in terms of a paragraph?), I'm just glad that something works. But I'll check into your solution above. I always learn something new when I try out a new technique. Thanks. D "StargateFanFromWork" wrote in message ... I absolutely must have cell margins that are at about 0.05" around the insides of Avery-sized labels #5167. Before changing the margins, the pages of labels are aligned and positioned correctly. The instant I change them to 0.05", the rows all become misaligned and a standard sheet has a row pushed off to the next page. About halfway throught the first page, the labels contents are printing half off the labels. The text before and after the merge in no way is too much for each cell and I made sure that the "automatically resize to fit contents" option is not selected in the table options of the table properties so I'm at a loss to figure out what is going on. The labels are not always printing correctly from sheet to sheet as, I'm sure most with experience have found, different batches of labels come out slight differently placed. I've not done much mail merge or label work as was the case back in my old word-processing days, but at the time I had working templates with table margins that worked for any label batches that came along. Through trial and error one eventually finds the margins that work to the maximums of label production offset and 0.05" is about the minimum to accommodate these offsets. Certainly, 0.08" (tEventually a margin is found that accommodates all slight variations between label stocks. But if I can't change the margins and retain the integrity of labels, then I'm stuck. Does anyone know what to do in this situation? I don't know what else to look at. 0.05" is not even my preference for label margins. In WP days, I'd use the standard WP size of 0.05" and I used to use 5167 even back then. Stuck and hoping someone here knows a good solution to this. Thanks! D |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error msg. "External component has thrown an exception" | Mailmerge | |||
Word: 'track changes": have "changed by" rather "del." and "inser | Microsoft Word Help | |||
Is "Keep with next" in "Paragraph" window the only way to keep table rows on one page? | Tables | |||
Is "Keep with next" in "Paragraph" window the only way to keep table rows on one page? | Formatting Long Documents | |||
disable "first letter of table cells" in "AutoCorrect" with regist | Microsoft Word Help |