How do I make a address book for mailing labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cheycheys - 22 Jan 2006 19:56 GMT

I just got my new computer XP from Dell and it has Microsoft Word and Excel
and Outlook. I prefer to use my Outlook Express for my email. What I have
been trying to figure out is how to make an address book. Not an email one
but an address book with names and address's so I can make labels for return
address's and labels to send out Christmas cards. Can someone please show me
how to do this, I am going nuts trying to figure it out! I'm not sure if I
should be trying to do this in Excel or Word. I do know I don't want to use
Outlook for anything at the moment. Any help would be much appreciated.

Reply to this Message

Peo Sjoblom - 22 Jan 2006 20:10 GMT

You could use Excel as a database where you store the addresses and Word to
print them

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

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

Signature

Regards,

Peo Sjoblom

Portland, Oregon

>I just got my new computer XP from Dell and it has Microsoft Word and
>Excel
[quoted text clipped - 11 lines]
> use
> Outlook for anything at the moment. Any help would be much appreciated.

Reply to this Message

David McRitchie - 22 Jan 2006 20:39 GMT

If you have the information already in your windows address book which
is used by Outlook Express and by Outlook you can export
File, Export, Other Address Book, text csv file
and open in Excel, you can move columns around with Shift+Drag selection boundary
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursor

To go the other way, you want to take a file created in Excel and import it to your
WAB, but it may be a little tricky and you definitely need to backup what you have first.
Then export the WAB to a spreadsheet to get the format (columns/titles, etc) correct,
so you have the correct information set up to inport to the WAB.
http://www.mvps.org/dmcritchie/excel/backup.htm
http://www.mvps.org/dmcritchie/excel/ofc2000.htm .

And you already have links for creating mailing labels with Excel as the database.

If you have nothing to start with -- I would make the spreadsheet have (if mostly US)
phoneno, lastname, firstname, address, ST, zip+4, email
you would have to match the titles as exported by WAB, if you are going to import into WAB,
and possible change the order and add a column so that the generated CSV file ends with
a comma on each line. .

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> You could use Excel as a database where you store the addresses and Word to
> print them
[quoted text clipped - 18 lines]
> > use
> > Outlook for anything at the moment. Any help would be much appreciated.

Reply to this Message

paul - 22 Jan 2006 23:58 GMT

mailmerge in word using excel as your source

Signature

paul
remove nospam for email addy!

> If you have the information already in your windows address book which
> is used by Outlook Express and by Outlook you can export
[quoted text clipped - 44 lines]
> > > use
> > > Outlook for anything at the moment. Any help would be much appreciated.

Reply to this Message

David McRitchie - 23 Jan 2006 08:17 GMT

Hi Paul,
FWIW, Peo already not only already said that but provided links on how to do the mail merge.
BTW, one of the links two links Peo supplied was one of mine.

Since an address book was mentioned, I added information on use of address
book to supply Excel data with an export, or from Excel to the address book
just in case that would be of interest, particularly because the address book was mentioned.

Since we are reiterating what has already been mentioned, I will repeat that anything
involving the windows address book must be preceded by backing it up.
---
HTH,
David McRitchie, http://www.mvps.org/dmcritchie/excel/excel.htm

Reply to this Message

cheycheys - 23 Jan 2006 17:35 GMT

Thanks for all the replies. It all looks like greek to me since I am a
beginner but I will try to follow the instructions. All I want to do is make
address's and it looks really complicated, I wouldn't think it would have to
be. Any chance anyone knows of a free program that would be easier then
this, would be great? Otherwise I will sit down and try to figure this one
out. Thanks for sending the instructions for me to follow, that will help a
lot.

Cheycheys

Reply to this Message

Realstar - 30 Jan 2006 19:57 GMT

I had a similar problem and found a "translator" on the Mircosoft site free.
It really helped me get things a little straighter in the XP Outlook address
book. But you might find Outlook is a much better email program than Outlook
Express because it allows many more options and is easier for others to view
links and attachments..

> Thanks for all the replies. It all looks like greek to me since I am a
> beginner but I will try to follow the instructions. All I want to do is make
[quoted text clipped - 28 lines]
> > > use
> > > Outlook for anything at the moment. Any help would be much appreciated.

Reply to this Message