Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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/...AMailMerge.htm -- Regards, Peo Sjoblom Portland, Oregon "cheycheys" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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...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. 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 "Peo Sjoblom" wrote in message ... 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/...AMailMerge.htm -- Regards, Peo Sjoblom Portland, Oregon "cheycheys" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
mailmerge in word using excel as your source
-- paul remove nospam for email addy! "David McRitchie" wrote: 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...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. 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 "Peo Sjoblom" wrote in message ... 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/...AMailMerge.htm -- Regards, Peo Sjoblom Portland, Oregon "cheycheys" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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 "Peo Sjoblom" wrote: 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/...AMailMerge.htm -- Regards, Peo Sjoblom Portland, Oregon "cheycheys" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a address book for mailing labels
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.. "cheycheys" wrote: 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 "Peo Sjoblom" wrote: 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/...AMailMerge.htm -- Regards, Peo Sjoblom Portland, Oregon "cheycheys" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Address Labels in Excel | Excel Discussion (Misc queries) | |||
Can you make a Excel hyperlink connect to an outlook address card | Excel Discussion (Misc queries) | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
How do I make mailing labels from an excel document? | Setting up and Configuration of Excel | |||
how do I set up my address book? | New Users to Excel |