Apologies in advance as this is a mixed query about using excel to
import data into Outlook.

I want to create a new distribution list of 500 or so emails in Outlook
(legitimate use, I'm not a spammer!).

Problem is I do not want to enter each one individually as a in contact
Outlook, so they do not yet appear in the list to select for adding to a
DL.

My solution was to create a new contacts folder in Outlook and export
this blank file to excel.

I then populates the email address and email alias fields with my 500
email addresses. Also populated the emailtype field with value 'SMTP'
and the catergories field so that I can merge with my main contacts at
some point and still identify these email addresses.

I then try to import this back into the new balnk contacts folder and
Outlook goes through the motions but nothing is copied to my new
folder.

Might anyone here know what I am doing wrong? I am sure that this
should work.


--
kevvyb2
------------------------------------------------------------------------
kevvyb2's Profile: http://www.excelforum.com/member.php...o&userid=22024
View this thread: http://www.excelforum.com/showthread...hreadid=547679