software

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.You could use Excel as a database where you store the addresses and Word to
print themwww.mvps.org/dmcritchie/excel/mailmerg.htmword.mvps.org/FAQs/MailMerge/...AMailMerge.htm

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;cheycheysquot; gt; wrote in message
...
gt;I just got my new computer XP from Dell and it has Microsoft Word and
gt;Excel
gt; and Outlook. I prefer to use my Outlook Express for my email. What I
gt; have
gt; been trying to figure out is how to make an address book. Not an email
gt; one
gt; but an address book with names and address's so I can make labels for
gt; return
gt; address's and labels to send out Christmas cards. Can someone please show
gt; me
gt; how to do this, I am going nuts trying to figure it out! I'm not sure if
gt; I
gt; should be trying to do this in Excel or Word. I do know I don't want to
gt; use
gt; Outlook for anything at the moment. Any help would be much appreciated.
gt;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
www.mvps.org/dmcritchie/excel...and.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.
www.mvps.org/dmcritchie/excel/backup.htm
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Peo Sjoblomquot; gt; wrote in message ...
gt; You could use Excel as a database where you store the addresses and Word to
gt; print them
gt;
gt;
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt;
gt;
gt; word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;cheycheysquot; gt; wrote in message
gt; ...
gt; gt;I just got my new computer XP from Dell and it has Microsoft Word and
gt; gt;Excel
gt; gt; and Outlook. I prefer to use my Outlook Express for my email. What I
gt; gt; have
gt; gt; been trying to figure out is how to make an address book. Not an email
gt; gt; one
gt; gt; but an address book with names and address's so I can make labels for
gt; gt; return
gt; gt; address's and labels to send out Christmas cards. Can someone please show
gt; gt; me
gt; gt; how to do this, I am going nuts trying to figure it out! I'm not sure if
gt; gt; I
gt; gt; should be trying to do this in Excel or Word. I do know I don't want to
gt; gt; use
gt; gt; Outlook for anything at the moment. Any help would be much appreciated.
gt; gt;
gt;
mailmerge in word using excel as your source
--
paul
remove nospam for email addy!
quot;David McRitchiequot; wrote:

gt; If you have the information already in your windows address book which
gt; is used by Outlook Express and by Outlook you can export
gt; File, Export, Other Address Book, text csv file
gt; and open in Excel, you can move columns around with Shift Drag selection boundary
gt; www.mvps.org/dmcritchie/excel...and.htm#cursor
gt;
gt; To go the other way, you want to take a file created in Excel and import it to your
gt; WAB, but it may be a little tricky and you definitely need to backup what you have first.
gt; Then export the WAB to a spreadsheet to get the format (columns/titles, etc) correct,
gt; so you have the correct information set up to inport to the WAB.
gt; www.mvps.org/dmcritchie/excel/backup.htm
gt; www.mvps.org/dmcritchie/excel/ofc2000.htm .
gt;
gt; And you already have links for creating mailing labels with Excel as the database.
gt;
gt; If you have nothing to start with -- I would make the spreadsheet have (if mostly US)
gt; phoneno, lastname, firstname, address, ST, zip 4, email
gt; you would have to match the titles as exported by WAB, if you are going to import into WAB,
gt; and possible change the order and add a column so that the generated CSV file ends with
gt; a comma on each line. .
gt;
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message ...
gt; gt; You could use Excel as a database where you store the addresses and Word to
gt; gt; print them
gt; gt;
gt; gt;
gt; gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; gt;
gt; gt;
gt; gt; word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;cheycheysquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I just got my new computer XP from Dell and it has Microsoft Word and
gt; gt; gt;Excel
gt; gt; gt; and Outlook. I prefer to use my Outlook Express for my email. What I
gt; gt; gt; have
gt; gt; gt; been trying to figure out is how to make an address book. Not an email
gt; gt; gt; one
gt; gt; gt; but an address book with names and address's so I can make labels for
gt; gt; gt; return
gt; gt; gt; address's and labels to send out Christmas cards. Can someone please show
gt; gt; gt; me
gt; gt; gt; how to do this, I am going nuts trying to figure it out! I'm not sure if
gt; gt; gt; I
gt; gt; gt; should be trying to do this in Excel or Word. I do know I don't want to
gt; gt; gt; use
gt; gt; gt; Outlook for anything at the moment. Any help would be much appreciated.
gt; gt; gt;
gt; gt;
gt;
gt;
gt;

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, www.mvps.org/dmcritchie/excel/excel.htm

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

quot;Peo Sjoblomquot; wrote:

gt; You could use Excel as a database where you store the addresses and Word to
gt; print them
gt;
gt;
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt;
gt;
gt; word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;cheycheysquot; gt; wrote in message
gt; ...
gt; gt;I just got my new computer XP from Dell and it has Microsoft Word and
gt; gt;Excel
gt; gt; and Outlook. I prefer to use my Outlook Express for my email. What I
gt; gt; have
gt; gt; been trying to figure out is how to make an address book. Not an email
gt; gt; one
gt; gt; but an address book with names and address's so I can make labels for
gt; gt; return
gt; gt; address's and labels to send out Christmas cards. Can someone please show
gt; gt; me
gt; gt; how to do this, I am going nuts trying to figure it out! I'm not sure if
gt; gt; I
gt; gt; should be trying to do this in Excel or Word. I do know I don't want to
gt; gt; use
gt; gt; Outlook for anything at the moment. Any help would be much appreciated.
gt; gt;
gt;
gt;

I had a similar problem and found a quot;translatorquot; 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..quot;cheycheysquot; wrote:

gt; Thanks for all the replies. It all looks like greek to me since I am a
gt; beginner but I will try to follow the instructions. All I want to do is make
gt; address's and it looks really complicated, I wouldn't think it would have to
gt; be. Any chance anyone knows of a free program that would be easier then
gt; this, would be great? Otherwise I will sit down and try to figure this one
gt; out. Thanks for sending the instructions for me to follow, that will help a
gt; lot.
gt;
gt; Cheycheys
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; You could use Excel as a database where you store the addresses and Word to
gt; gt; print them
gt; gt;
gt; gt;
gt; gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; gt;
gt; gt;
gt; gt; word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;cheycheysquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I just got my new computer XP from Dell and it has Microsoft Word and
gt; gt; gt;Excel
gt; gt; gt; and Outlook. I prefer to use my Outlook Express for my email. What I
gt; gt; gt; have
gt; gt; gt; been trying to figure out is how to make an address book. Not an email
gt; gt; gt; one
gt; gt; gt; but an address book with names and address's so I can make labels for
gt; gt; gt; return
gt; gt; gt; address's and labels to send out Christmas cards. Can someone please show
gt; gt; gt; me
gt; gt; gt; how to do this, I am going nuts trying to figure it out! I'm not sure if
gt; gt; gt; I
gt; gt; gt; should be trying to do this in Excel or Word. I do know I don't want to
gt; gt; gt; use
gt; gt; gt; Outlook for anything at the moment. Any help would be much appreciated.
gt; gt; gt;
gt; gt;
gt; gt;