Mailing List From Excel
Why won’t all my addresses from excel print in my word 2007 mail merge?
Last year I created an address list in Excel. The labels printed fine then. This year, when I try to create a mail merge again, it won’t print all the addresses. It stops with the “L” names. Please help!
Try redefining your data area. You may have amended the list by adding extra data to it but neglected to redefine the area used. By not redefining the database area the Mail Merge will only use the earlier range area. Select the whole area you are using for your list, goto Name Manager and amend the range’s last reference to the new larger reference cell. This should then allow Word to correctly print out the labels.
Training Needs Analysis