Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with a distribution list

Status
Not open for further replies.

Haleon

IS-IT--Management
Feb 2, 2004
80
US
Hey guys, here's the situation. I have an Excel document with a 140 email addresses and names in it, and my boss wants me to create a distribution list for all the people in the list. Is there an easy way to go about doing this, or do I have to create individual contacts for all of them and then create the distribution list? Any help would be appreciated. thank you!!
 
Well, it is a bit difficult to create a list when AD does not know about them, right?
So, yes, you will need to enter them. If they are all outside contacts, they all need to be Custom Recipient.

Marc
[sub]If 'something' 'somewhere' gives 'some' error, expect random guesses or no replies at all.
Free Tip: The F1 Key does NOT destroy your PC!
[/sub]

Have a look at the shop @ !
 
Hmmm.... is there any way to bulk-create custom recipients then, or is this just something I'm going to have to do by hand?
 
What you could do is go to outlook and export a contacts folder to CSV (windows). Open this document in excel to get your template then open the document with the 140 e-mail address and copy and paste into the apppriate column.

Open your Outlook and create a new contacts folder (just to keep it seperate). Go to - File - Import/Export - Import from another file - Comma seperated values (Windows)*Note you may need to install it - Pick the csv file

Once in outlook a distribution list is easy to set up.

That should do it.

Goner05
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top