Open a new workbook.

In Sheet1 you will enter your titles across the row in individual cells.

LastName FirstName Address City State Zip (and whatever else you wish)

Last column title it Type

Now assuming John Doe has two addresses...one personal and one business.

Row 2 enter Doe John 123 main st. Albany NY 12345 enter a P in the Type
column

Row 3 enter Doe John 456 main st. Albany NY 67890 enter B in the Type
column.

Do this for each person in your list. If it is a personal address enter a P

When you want to print mailing labels, do it through Word with Excel as the
data source.

You can filter or query on the P's and B's in the Type column.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 15:56:02 -0800, "Grammurph7"
wrote:

I want to set up an address data base in Excel. They would be a combination
of personal and business addresses. I want to be able to separate them for
the purpose of printing mailing labels. I am new to Office, could someone
suggest a template or solution ? Thank you.