Word, Mail Merge, labels, Include all rows from Excel?

[Guest]

Using Word Mail Merge and printing labels, connecting to an Excel file with
names/addresses, document only displays/prints one sheet of labels. It does
not capture all the names/addresses on the Excel file. How do I get it to
print more than one sheet of labels with the rest of the names/addresses? I
have checked all boxes to be included.

 

[Vincent Johns]

Have you successfully imported all of the names/addresses into Access?
(I know you didn't mention Access, but this IS a Microsoft Office Access
newsgroup.) I expect that your list will be easier to maintain in
Access than in Excel, though perhaps you're not the person doing the
maintenance. (For example, Access will let you keep all the information
-- name, city, &c. -- for each label together in one record, whereas in
Excel each field is probably in a separate cell and there is no inherent
linking mechanism there.) If you don't have control over the Excel
file, perhaps because someone else maintains it, you can link it into
your Access database as an external Table.

In your Access database, you can easily inspect your list, count the
number of labels, etc., and then use Word Mail Merge to print whatever
labels you need. You can filter the list either in your Access Query or
in Mail Merge.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.