+ Reply to Thread
Results 1 to 5 of 5

.xls to OE address book

  1. #1
    frankg
    Guest

    .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. #2
    Peo Sjoblom
    Guest

    Re: .xls to OE address book

    Save as CSV and then import it

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "frankg" <sorry@stoppingspam.com> wrote in message
    news:5dyye.2813$is5.354565@news20.bellglobal.com...
    > 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. #3
    frankg
    Guest

    Re: .xls to OE address book

    Thank you.


    "Peo Sjoblom" <terre08@mvps.org> wrote in message
    news:eoGde5XgFHA.3132@TK2MSFTNGP10.phx.gbl...
    > Save as CSV and then import it
    >
    > --
    > Regards,
    >
    > Peo Sjoblom
    >
    > (No private emails please)
    >
    >
    > "frankg" <sorry@stoppingspam.com> wrote in message
    > news:5dyye.2813$is5.354565@news20.bellglobal.com...
    >> 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. #4
    Gord Dibben
    Guest

    Re: .xls to OE address book

    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
    >
    >



  5. #5
    frankg
    Guest

    Re: .xls to OE address book

    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
    >>
    >>

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1