Re: Is it possible to import e-mail address from Excel?

From: Kath Adams (KathAdams_at_mvps(remove).org)
Date: 02/01/04 

Date: Sun, 1 Feb 2004 17:11:52 -0000

BigBuck98 wrote:
> I have a database in Excel with 426 entries. Each of these entries
> has among other things e-mail addresses. Is there any way that I can
> import these addresses and the name of the person from this Excel
> database into the address book in OE 6.0?
> Thanks
> Gordon

Courtesy of Frank Saunders MVP :-

Arrange the data fields so they agree with
the following headers (or columns) and save the result as a CSV (comma
separated value) file. You can import a CSV file into Outlook Express
using
File/Import/Other Address Book (Text-CSV file). The header info and
order
they must be in are as follows:

First Name,Last Name,Middle Name,Name,Nickname,E-mail Address,Home
Street,Home City,Home Postal Code,Home State,Home Country/Region,Home
Phone,Home Fax,Mobile Phone,Personal Web Page,Business Street,Business
City,Business Postal Code,Business State,Business
Country/Region,Business
Web Page,Business Phone,Business Fax,Pager,Company,Job
Title,Department,Office Location,Notes 

-- 
Kath Adams
MS MVP - Windows (IE/OE)

Relevant Pages

  • Re: Basic Program to Import a CSV file
    ... Given that the OP asked about importing a CSV file into UV, ... some Excel to MV tool to import a CSV file into UV? ... Hey, why stop at replacing the database, replace the spreadsheet tools ... The directory file may well be UV ...
    (comp.databases.pick)
  • Re: Reconciling Employee Forms and Database Records
    ... You could also use Excel as the file format to send the data out and import ... the document the form loads from the CSV file and when they update a field ... > I have an employee database. ... provided the data that the database stores. ...
    (microsoft.public.access.externaldata)
  • Re: Is it possible to import e-mail address from Excel?
    ... > gives me a failure message. ... >> I have a database in Excel with 426 entries. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: How to supply your own web query
    ... Or to compile the information in an executible which excel can load into ... > thought of getting round it is to allow the user to download the csv file ... >> If you are just providing internally maybe think of a database. ... >> for the internet, just upload your file as a csv file for download is ...
    (microsoft.public.excel.programming)
  • Re: Newbie question: Importing .csv data into Java DB tables
    ... There's no "standardized" way of importing in such a way into a database, ... a .csv file, or equivalent) and use THAT as a database table within ... Yes, it is, but you can even use Excel itself as a DB. ... Microsofts ODBC-driver for Excel. ...
    (comp.lang.java.databases)