Re: How to import a large list of contacts?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi David,

You'll note in the third line that the Name field info is missing, but there
is a second comma showing that the field has no data. In other words, there
is nothing between the two commas.

Yes, the "Name" field is the Display Name.

The snowfall in the mountains was low last winter. Bad news for skiers. The
good news is ever since a drought was declared near the end of winter the
weather has been cool and wet. There has now been enough water from spring
rainfall to supply summer needs -- if summer-like weather arrives this year.
We could use another "drought," now. <G>

--
Tim K.
aka Kuay Tim
MS-MVP - (IE/OE)
Lynnwood, WA
*
"DavidJ726" <DavidJ726@xxxxxxxxxxxxxxxx> wrote in message
news:Oda3lr7cFHA.1276@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Tim, This is exactly what I need.

I see you'r from my home state... What happened to the snow tin the
mountains his year :-)

I might have to put this off till tomorrow morning (it's 11:30 here) but I'm
wondering does the format have to stay the way you show it? I'm a little
lost in regards to the;

First Name,Last Name,Name,E-mail Address
Tim,Kauppila,aka Kuay Tim,kuaytim@xxxxxxxxxx
Tim,Kauppila,,kuaytim@xxxxxxxxxx

It seems in the example above, lines 1 & 2 corelate, but if data was entered
as shown in line 3, the wouldn't the first line need to change?

Also, is the aka and/or name what ends up in the "display" field?

Thanks,



"Kuay Tim" <TimJohn@xxxxxxx> wrote in message
news:Oac6yh7cFHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
> Hi David,
>
> You'll want the addresses in the form of a comma-separated values file. It
> may be possible to export the Excel file as a CSV file that will be almost
> ready for import into Outlook Express. However, I'm not an expert in
> Excel.
> A CSV file when used as "other address book" is a specially formatted text
> file that can include selected fields from the Windows Address Book. To
> see
> what the formatting looks like export an entry from the address book and
> view the file in Notepad. Choose the fields you want to import.
>
> When creating the CSV file for address book use save the Notepad document
> as
> "All Files," not as a "Text" file.
>
> More Information
> http://home.earthlink.net/~kuaytim/exportwab.htm
> Scroll down to "Create a Comma-Separated Values File (Workaround)" to see
> an
> example of the text with commas in the CSV file.
>
> --
> Tim K.
> aka Kuay Tim
> MS-MVP - (IE/OE)
> Lynnwood, WA
> *
> "DavidJ726" <DavidJ726@xxxxxxxxxxxxxxxx> wrote in message
> news:uA50cT7cFHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
> I've got an excel file with about 40 e-mail address's. Short of typing
> each
> one manually, how can I get them into OE5? I'm not seeing anything at the
> KB or in the forum.
>
> Thanks,
>
> David...
>
>
>



.

Relevant Pages

  • Re: How to import a large list of contacts?
    ... > Hi David, ... >> When creating the CSV file for address book use save the Notepad document ... >> aka Kuay Tim ... >> I've got an excel file with about 40 e-mail address's. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: How to import a large list of contacts?
    ... wondering does the format have to stay the way you show it? ... > may be possible to export the Excel file as a CSV file that will be almost ... > aka Kuay Tim ... > I've got an excel file with about 40 e-mail address's. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Export file to CSV delimited with fixed field length
    ... Generally, you use fixed fields without the commas (fixed-length), or ... variable-length fields with the commas. ... > I have an Excel file with a series of fields, ... > that when I export this file to a CSV file, I get a file in which each ...
    (microsoft.public.excel.misc)
  • Re: How to import a large list of contacts?
    ... A CSV file when used as "other address book" is a specially formatted text ... When creating the CSV file for address book use save the Notepad document as ... aka Kuay Tim ... I've got an excel file with about 40 e-mail address's. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: How do I allow blank columns in a .CSV file?
    ... I am using the csv file to upload data from excel to a website - the website ... "Dave Peterson" wrote: ... not buying much by making sure that there are extra commas in the file. ...
    (microsoft.public.excel.misc)