address data base in which I can choose which to use for mailing

[Grammurph7]

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.

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033


Gord Dibben Excel MVP

 

[Grammurph7]

Thank you, Gord. I used to have all my addresses in Access and access was
not included in the software on my new computer. I think your suggestion
just might work. I'm going to start reading through those links now. I'm
anxious to enter all my addresses back into the computer.

 

[gls858]

Thank you, Gord. I used to have all my addresses in Access and access was
not included in the software on my new computer. I think your suggestion
just might work. I'm going to start reading through those links now. I'm
anxious to enter all my addresses back into the computer.

If you already have an Access database, Access can be purchased separately.
If you have a previous version and upgrade isn't real expensive.
Also if you just open Excel and go to File > open browse to the mdb file
with your addresses you should be able to open the file and bring your data
right into Excel.

gls858

 

[Gord Dibben]

If you still have the Access *.mdb kicking around, Excel will open it as a new
workbook.


Gord