Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i convert a mailing list in excel to outlook
I have created a list of customers addresses in excel. I want to bring all
these into outlook for printing labels. I do not know if there is a way to convert or not. |
#2
|
|||
|
|||
The way I understand your question it seems to have 2 parts (help me if I am
wrong) a. You want to import your customer addresses into Outlook) b. You want to create labels (using Word)? "chvbob" wrote: I have created a list of customers addresses in excel. I want to bring all these into outlook for printing labels. I do not know if there is a way to convert or not. |
#3
|
|||
|
|||
I preferably want to go into Outlook with this. I tried a mail merge in Word,
and had no success. "Joy" wrote: The way I understand your question it seems to have 2 parts (help me if I am wrong) a. You want to import your customer addresses into Outlook) b. You want to create labels (using Word)? "chvbob" wrote: I have created a list of customers addresses in excel. I want to bring all these into outlook for printing labels. I do not know if there is a way to convert or not. |
#4
|
|||
|
|||
Don't know if it is possible, I always use Word but if it is an Outlook
question you are probably better off posting in an Outlook newsgroup I am sure it must be more comlicated than using Word though Regards, Peo Sjoblom "chvbob" wrote in message ... I preferably want to go into Outlook with this. I tried a mail merge in Word, and had no success. "Joy" wrote: The way I understand your question it seems to have 2 parts (help me if I am wrong) a. You want to import your customer addresses into Outlook) b. You want to create labels (using Word)? "chvbob" wrote: I have created a list of customers addresses in excel. I want to bring all these into outlook for printing labels. I do not know if there is a way to convert or not. |
#5
|
|||
|
|||
For the importing of addresses from Excel to Outlook.....
This is how I do it. The basics........Your layout may differ. Instructions here are for Name and Email address only, but adjust to suit for more columns. First have the names and email addresses(or in your case fax number)in Excel in two columns. I set up also a third column with the names duplicated so when you Import to Outlook you have a name for the Contact and a Display Name instead of the email address in the To: box. FileSave AsFile Type CSV(comma delimited)(*.csv) Click "Yes" when you get the messages about losing formats and "are you sure"? Close the file. Now open Outlook and FileImport/ExportImport from another fileComma Separated Values(Windows)NextFile to Import(you can browse to your saved *.csv file). Next you will be asked where to import them to. I bring mine to "Contacts". Follow the instructions and you will get a Map. Drag your names and addresses to the appropriate spots on the Map 1. Name of Contact 2. Email address1 3. Display Name(if you have one by making the duplicate column mentioned earlier). If not, the email address wil be displayed in the To: box. Continue with the OK's until Outlook pulls all from the *.csv file(should take only a few seconds). Now they are in the Contacts folder, you can group them as you wish. Making labels from Outlook is something I have never attempted. Gord Dibben Excel MVP On Thu, 13 Oct 2005 21:11:44 -0700, chvbob wrote: I have created a list of customers addresses in excel. I want to bring all these into outlook for printing labels. I do not know if there is a way to convert or not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailing List | New Users to Excel | |||
How can I convert an Excel file to an Adobe .pdf file by using Ex. | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions |