Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Grammurph7 - 15 Dec 2005 23:56 GMT
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 - 16 Dec 2005 00:31 GMT
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

>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.
Grammurph7 - 16 Dec 2005 01:08 GMT
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.

> Open a new workbook.
>
[quoted text clipped - 37 lines]
> >the purpose of printing mailing labels.  I am new to Office, could someone
> >suggest a template or solution ?  Thank you.
gls858 - 16 Dec 2005 16:53 GMT
> 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
[quoted text clipped - 42 lines]
>>> the purpose of printing mailing labels.  I am new to Office, could someone
>>> suggest a template or solution ?  Thank you.

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 - 16 Dec 2005 20:11 GMT
If you still have the Access *.mdb kicking around, Excel will open it as a new
workbook.

Gord

>> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.