script to import csv into distribution list in exchange console

Question

script to import csv into distribution list in exchange console

rmcguire80 (IS/IT--Management)

(OP)

16 Dec 13 10:34

Hello,

I'm trying to setup this script to import a csv into a distribution list in exchange console:

Import-CSV FileName.csv | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}

But when I run the script in the exchange console shell. I receive the following:

Cannot find object "ALEXCLARK" Please make sure that it was spelled correctly or specify a different object.

I've attached my .csv, if someone could tell me why this won't add this address to a new distribution group

My CSV just has the 1st row

Name PrimarySMTPAddress
ALEXCLARK his email address

markdmac (MIS) · Answer 1 · 2014-06-11 17:14:28

Your sample for the CSV appears to be inco0mplete since it does not actually include any commas. Please confirm you are actually using a CSV and not a tab delimited file. If it is tab delimited then you need to specify your delimiter when importing the data.

CODE

Import-CSV FileName.csv -Delimiter "`t" | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}

I hope that helps.

Regards,

Mark

Check out my scripting solutions at http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

Come Join Us!

Posting Guidelines

script to import csv into distribution list in exchange console