thanks !
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:m9llc1h448it86h5us5b76c2nssvkk6jdq@4ax.com...
> 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.
>
> File>Save As>File 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 File>Import/Export>Import from another file>Comma
> Separated Values(Windows)>Next>File 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" <sorry@stoppingspam.com>
> 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
>>
>>
>
Bookmarks