Copy Email addresses to Outlook Express

[Lon]

I have a list of email addresses in an Excel column that I would like to
copy into Outlook Express. Is there a way to do this?

[David McRitchie]

Hi Lon,
Backup your Windows Address Book before doing anything (*.WAB)
Same file (.WAB) is used by both Outlook Express and by Outlook.

You will need one extra column of data in your Excel file, because the WAB
when using Import of a CSV file requires an ending comma.

Export from your WAB so that you can get the format of the column headings then
you can import them back in with your new data or maybe just import the new
data in the correct format -- but that's why the backup is important.

In your address book under File you will see import and export and you want
that to be Test File (csv - Comma Separated Values) so you can make changes.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lon" <[email protected]> wrote in message news:kpLRf.11033$Km6.8632@trnddc01...
> I have a list of email addresses in an Excel column that I would like to
> copy into Outlook Express. Is there a way to do this?
>
>

[Lon]

Thanks David. That worked like a charm.

"David McRitchie" <[email protected]> wrote in message
news:uicRHF%[email protected]...
> Hi Lon,
> Backup your Windows Address Book before doing anything (*.WAB)
> Same file (.WAB) is used by both Outlook Express and by Outlook.
>
> You will need one extra column of data in your Excel file, because the WAB
> when using Import of a CSV file requires an ending comma.
>
> Export from your WAB so that you can get the format of the column headings
> then
> you can import them back in with your new data or maybe just import
> the new
> data in the correct format -- but that's why the backup is important.
>
> In your address book under File you will see import and export and
> you want
> that to be Test File (csv - Comma Separated Values) so you can make
> changes.
>
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Lon" <[email protected]> wrote in message
> news:kpLRf.11033$Km6.8632@trnddc01...
>> I have a list of email addresses in an Excel column that I would like to
>> copy into Outlook Express. Is there a way to do this?
>>
>>
>
>
>