• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

How to import e-mail addresses from a text list to a contact list

I have created a contact list in my Exchange 2003 Public Folder List. I need to import e-mail addresses from a text file into that contact list. Is there a way to do this?
0
CADRE308
Asked:
CADRE308
  • 4
  • 3
1 Solution
 
millemaCommented:
I don't think you can do this directly into the Public Folder, but what you can do is import the text file into an Outlook contacts folder, and then copy these items over to the Public Folder.  You'll want to create a CSV file with at least two fields - the SMTP address and a second field of "SMTP".  When performing the import you'll need to perform field mapping for the Email Address and Address Type (SMTP) of the contact.  You can include additional fields (name, company, phone number, etc.) if you have this data.  After the import you can then drag these new contacts over to the Public Folder.
0
 
CADRE308Author Commented:
All I have are names and e-mail addresses. so the two fields should be "Name and E-Mail Address?
0
 
millemaCommented:
Yes, but when doing the import you'll also have to map a field for the address type.  If you open the file as a CSV from Excel, add a third column "SMTP".  During the import you'll get to a screen where you can select the field mappings - the Email Address requires both the address and the address type.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
CADRE308Author Commented:
I'll try it now. Thanks,
0
 
CADRE308Author Commented:
I can't seem to create the csv file. This is what i have.
I have a Text file in the following format with about 300+ names and e-mail addresses.
A. J. Doe (adoe@isp.edu); A. J. Doe (jdoe@abc.net)
A. J. Dow would be the Student and the tow e-mail addresses wold be for each parent.
I can't figure oug how to get the contents of the text file into a CSV file I tried to open the text file with excel in comma delimited but all of the addresses ended on row 2 all the way across.

I apreciate all the help, I'm not much on scripting
0
 
millemaCommented:
This is a complex data source but you should be able to make it work.  First open it in wordpad or notepad.  Since it appears you have it semi-colon delimited you can search and replace the semicolons with commas.  Next you'll need to open with Excel.  It will have all the data on the first row, so what you need to do is select the row to copy, then select the first column on row 2.  Select Edit, Paste Special, then enable the "Transpose" check box.  Now you have a column of data, so delete Row 1.

Next you need to separate the student name and it's associated SMTP address.  Enable the auto-filter and filter for values that contain an @ sign.  Cut and paste these to column 2.  You should now have two columns, the first with the student name and and the second with the address.  Save as a CSV file after verifying the names and addresses match.  Now you can import these using the procedures from earlier.  You may have to do two batches since not all students will have two email addresses, so you'll probably need to parse through the data to segregate the single email students from those with two.
0
 
CADRE308Author Commented:
That did the trick. Thanks for all of your help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now