Solved

Adding bulk SMTP addresses to distribution group in Exchange

Posted on 2016-08-24
3
54 Views
Last Modified: 2016-08-24
Hi Folks,

I'm trying to bulk add a group of SMTP addresses to a distribution group.  The CSV content is such:

user1@systems.com,user2@systems.com,user3@systems.com

Import-CSV D:\Scripts\Test\dist-list.csv | ForEach {Add-DistributionGroupMember -Identity "ALLKSATestStaff" -Member $_}

Open in new window


When I run this through the Exchange Management Shell, it executes without any errors, but the distribution group is not updated - any ideas?

Thanks in advance
0
Comment
Question by:khanfe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 28

Assisted Solution

by:Michael Pfister
Michael Pfister earned 250 total points
ID: 41768741
Import-CSV expects each entry in a seperate line.


i.e.


user1@systems.com
user2@systems.com
user3@systems.com
0
 
LVL 16

Accepted Solution

by:
FOX earned 250 total points
ID: 41768748
name the header that contains your email addresses Alias
Import-CSV "D:\Scripts\Test\dist-list.csv" | ForEach {Add-DistributionGroupMember -Identity "ALLKSATestStaff" -Member $_.Alias}
0
 

Author Comment

by:khanfe
ID: 41768761
Thanks folks - Both your suggestions worked for the different issues - it's now working!
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question