Home |
Search |
Today's Posts |
#1
|
|||
|
|||
.xls to OE address book
How can I take an excel file (2 columns - one with names and the other with
email addresses) and export/convert/import it into my OE address book? thanks Frank |
#2
|
|||
|
|||
Save as CSV and then import it
-- Regards, Peo Sjoblom (No private emails please) "frankg" wrote in message .. . How can I take an excel file (2 columns - one with names and the other with email addresses) and export/convert/import it into my OE address book? thanks Frank |
#3
|
|||
|
|||
Thank you.
"Peo Sjoblom" wrote in message ... Save as CSV and then import it -- Regards, Peo Sjoblom (No private emails please) "frankg" wrote in message .. . How can I take an excel file (2 columns - one with names and the other with email addresses) and export/convert/import it into my OE address book? thanks Frank |
#4
|
|||
|
|||
Frank
This is how I do it for MS Outlook. Perhaps OE is similar? 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 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. Gord Dibben Excel MVP On Tue, 5 Jul 2005 12:04:35 -0400, "frankg" wrote: How can I take an excel file (2 columns - one with names and the other with email addresses) and export/convert/import it into my OE address book? thanks Frank |
#5
|
|||
|
|||
thanks !
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Frank This is how I do it for MS Outlook. Perhaps OE is similar? 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 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. Gord Dibben Excel MVP On Tue, 5 Jul 2005 12:04:35 -0400, "frankg" wrote: How can I take an excel file (2 columns - one with names and the other with email addresses) and export/convert/import it into my OE address book? thanks Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel as address book | Excel Discussion (Misc queries) | |||
HOW DO I TRANSFER MY ADDRESS BOOK FROM MICROSOFT EXCEL TO PALM DE. | Excel Discussion (Misc queries) | |||
Using Outlook address book in Excel | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
address book | Excel Discussion (Misc queries) |