merge labels from an excel wksheet w 3 sheets. Help!

P

puzzled in modesto

I am trying to mail merge labels for mass mailing from an excel file. There
are 3 worksheets in the file but only the first sheets will merge. The sheet
that pops up will only let me select sheet 1. How do I get all of the names
from the database on the labels?
 
B

Beth Melton

You'll need to combine them on a single worksheet or add another sheet
that references all of them to combine them.

Now, if the reason you separated them on multiple sheets is due to a
common element, such as region, company, etc, then simply add another
field to your data and add an identifier for the element.

Doing so will give you more flexibility and you can easily limit the
view of your data for a specific identifier by using
Data/Filter/AutoFilter.

If you must keep the data separated then use Access instead of Excel
and create a Union query that combines each table into a single view
instead.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Office 2007 Preview Site:
http://www.microsoft.com/office/preview/default.mspx
Office 2007 Community Articles/Tutorials:
http://www.microsoft.com/office/preview/community/article_archive.mspx

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"puzzled in modesto" <puzzled in [email protected]>
wrote in message
news:[email protected]...
 
Top