Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7
down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
I have just tried the same Excel file with a Directory type merge - it works
fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
You probably have an excess «Next Record» field. If this field is at the top
of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
Thanks, Suzanne.
My fields a «Name» «Company» «Address1» «Address2» «Town» «County» «Postcode»«Next Record» without a «Next Record» on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. -- "Suzanne S. Barnhill" wrote in message ... You probably have an excess «Next Record» field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
That appears to be as it should be, then, and, especially if the merge works
correctly at home, it's a mystery why it wouldn't at work. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "ab" wrote in message ... Thanks, Suzanne. My fields a «Name» «Company» «Address1» «Address2» «Town» «County» «Postcode»«Next Record» without a «Next Record» on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. -- "Suzanne S. Barnhill" wrote in message ... You probably have an excess «Next Record» field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
It might help, if you are running Word 2003, if you add the mail merge
toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
Sorry for delay in saying thanks to Graham and Suzanne - I've only just had
time to try this at my office. It works fine. Having done the labels, I would like to save a directory-style document showing the addressees (to be amended next year, as appropriate). Is it possible to arrange the names and addresses in a table with one cell to each addressee? I've tried Columns but these look rather uneven and I think a table would be easier to read. TIA "Graham Mayor" wrote in message ... It might help, if you are running Word 2003, if you add the mail merge toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
Using the same data source you used to create the labels, you can generate a
"directory" merge using columns, as you've already tried. If you want a table, it's easier to start with a "label" merge, since that's all labels are. Alternatively, create a "directory" merge using a single-row table with your form fields in each cell; you'll need "Next Record" fields in the cells after the first. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... Sorry for delay in saying thanks to Graham and Suzanne - I've only just had time to try this at my office. It works fine. Having done the labels, I would like to save a directory-style document showing the addressees (to be amended next year, as appropriate). Is it possible to arrange the names and addresses in a table with one cell to each addressee? I've tried Columns but these look rather uneven and I think a table would be easier to read. TIA "Graham Mayor" wrote in message ... It might help, if you are running Word 2003, if you add the mail merge toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#9
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
Thanks again, Suzanne
"Suzanne S. Barnhill" wrote in message ... Using the same data source you used to create the labels, you can generate a "directory" merge using columns, as you've already tried. If you want a table, it's easier to start with a "label" merge, since that's all labels are. Alternatively, create a "directory" merge using a single-row table with your form fields in each cell; you'll need "Next Record" fields in the cells after the first. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... Sorry for delay in saying thanks to Graham and Suzanne - I've only just had time to try this at my office. It works fine. Having done the labels, I would like to save a directory-style document showing the addressees (to be amended next year, as appropriate). Is it possible to arrange the names and addresses in a table with one cell to each addressee? I've tried Columns but these look rather uneven and I think a table would be easier to read. TIA "Graham Mayor" wrote in message ... It might help, if you are running Word 2003, if you add the mail merge toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#10
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
I would use the table option as it is easier to maintain and Word is happier
using tables as data sources. You will have to add a row for the field names. However as you already have the data in Excel why not simply use the Excel file, or copy the relevant parts of the Excel file to Word? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Using the same data source you used to create the labels, you can generate a "directory" merge using columns, as you've already tried. If you want a table, it's easier to start with a "label" merge, since that's all labels are. Alternatively, create a "directory" merge using a single-row table with your form fields in each cell; you'll need "Next Record" fields in the cells after the first. "oe" wrote in message ... Sorry for delay in saying thanks to Graham and Suzanne - I've only just had time to try this at my office. It works fine. Having done the labels, I would like to save a directory-style document showing the addressees (to be amended next year, as appropriate). Is it possible to arrange the names and addresses in a table with one cell to each addressee? I've tried Columns but these look rather uneven and I think a table would be easier to read. TIA "Graham Mayor" wrote in message ... It might help, if you are running Word 2003, if you add the mail merge toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
#11
Posted to microsoft.public.word.newusers
|
|||
|
|||
Missing labels
The OP already has a data source; I'm not sure why he/she is wanting to
create this additional reference document. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham Mayor" wrote in message ... I would use the table option as it is easier to maintain and Word is happier using tables as data sources. You will have to add a row for the field names. However as you already have the data in Excel why not simply use the Excel file, or copy the relevant parts of the Excel file to Word? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: Using the same data source you used to create the labels, you can generate a "directory" merge using columns, as you've already tried. If you want a table, it's easier to start with a "label" merge, since that's all labels are. Alternatively, create a "directory" merge using a single-row table with your form fields in each cell; you'll need "Next Record" fields in the cells after the first. "oe" wrote in message ... Sorry for delay in saying thanks to Graham and Suzanne - I've only just had time to try this at my office. It works fine. Having done the labels, I would like to save a directory-style document showing the addressees (to be amended next year, as appropriate). Is it possible to arrange the names and addresses in a table with one cell to each addressee? I've tried Columns but these look rather uneven and I think a table would be easier to read. TIA "Graham Mayor" wrote in message ... It might help, if you are running Word 2003, if you add the mail merge toolbar (see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ). Open the merge document and ensure that the document type is set to mailing labels. Setup the first label (without a next record field) as you want it to appear (ignore the rest of the labels). then click the propagate button. This will correct the label format based on what you have in that first cell. Save the merge document and then run the merge again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: Thanks, Suzanne. My fields a +Name; +Company; +Address1; +Address2; +Town; +County; +Postcode;+Next Record; without a +Next Record; on the last label. I have brought the files home with me and they work fine on my own PC - I will have to have another go on Monday when I get back to my office. "Suzanne S. Barnhill" wrote in message ... You probably have an excess +Next Record; field. If this field is at the top of the label, there should not be one in the first label; if it's at the bottom, there shouldn't be one on the last label. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "oe" wrote in message ... I have just tried the same Excel file with a Directory type merge - it works fine!! I really don't understand why it goes wrong with a label merge. TIA "oe" wrote in message ... I am doing a mail merge from an Excel sheet onto Avery labels (2 across/7 down). I have 62 addresses which all appear to be correct when I open the "open data source" in Word. I select All and do the merge. For some reason, some labels are missing - as far as I can tell at the end of a sheet of labels, i.e. Recipients 15, 30, 45 and 60. Can anyone help, please? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm doing a mail merge and missing labels | Microsoft Word Help | |||
Mail merge to continuous labels skips labels between pages | Mailmerge | |||
Label sheets with repeating labels in place of missing entries | Mailmerge | |||
missing field creates a space when printing labels | Mailmerge | |||
Missing lines in mail merge labels | Mailmerge |