R
R.M. Wilkinson
Greetings Office Experts!
I am perplexed at some behavior in Word 2007 when using Mail Merge. I am
merging from Excel 2007 mailing lists. I have tried several different lists
and get consistent results.
When walking through the Mail Merge Wizard I get to the point of "Update All
Labels" after choosing "Address Block" as the style I want. I have chosen
Avery 5960 labels BTW. After I hit "Update All Labels" the first three
labels across the top row and the last two labels on the bottom right update
the fields to say «Next Record»«AddressBlock». (Actually the first block
says only «AddressBlock» - the next two at the top say «Next
Record»«AddressBlock» and the last two on the bottom of the page say «Next
Record»«AddressBlock») The rest of the page in between just shows «Next
Record».
This is consistent across reboots, restarting Word and with different Excel
spreadsheets as the source for the addresses. Also the first three are
correct (in order) then the next 25 are blank and address numbers 29 and 30
show at the bottom so it is skipping the middle 25 addresses. If I have
1,000 addresses all 33 sheets of labels are the same way.
Has anyone else seen this or can explain it??
Thank You!
I am perplexed at some behavior in Word 2007 when using Mail Merge. I am
merging from Excel 2007 mailing lists. I have tried several different lists
and get consistent results.
When walking through the Mail Merge Wizard I get to the point of "Update All
Labels" after choosing "Address Block" as the style I want. I have chosen
Avery 5960 labels BTW. After I hit "Update All Labels" the first three
labels across the top row and the last two labels on the bottom right update
the fields to say «Next Record»«AddressBlock». (Actually the first block
says only «AddressBlock» - the next two at the top say «Next
Record»«AddressBlock» and the last two on the bottom of the page say «Next
Record»«AddressBlock») The rest of the page in between just shows «Next
Record».
This is consistent across reboots, restarting Word and with different Excel
spreadsheets as the source for the addresses. Also the first three are
correct (in order) then the next 25 are blank and address numbers 29 and 30
show at the bottom so it is skipping the middle 25 addresses. If I have
1,000 addresses all 33 sheets of labels are the same way.
Has anyone else seen this or can explain it??
Thank You!