Create DLs from CSV

At my current employer, we are constantly bringing on new customers. As I detailed in my VBScript version, it's a fairly complex environment.

The attached Powershell script does the following:

  1. Read CSV file of distribution list properties. (Alias, displayname, email address, etc.)
  2. Check then create each new DL
  3. Populate secondary properties on each DL like, proxy addresses, Allowed Senders, Size limits, and members.
  4. Define owner, and grant modify permissions to Associated External Account

Requirements:

  • Exchange 2007 Powershell cmdlets
  • Quest Active Roles Powershell cmdlets
  • CSV File with the following fieldsnames:
    • Alias
    • Displayname
    • PrimarySMTPAddress (can be all smtp addresses seperated by ;
    • mdbquota (in MB) (mailbox send/receive attachment limit)
    • AcceptMessagesFrom - List of names or DLs, ; seperated that can send to this DL.
    • Members - names of all recipients
AttachmentSize
Create-DLsFromCSV.zip2.1 KB

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <blockquote> <center> <hr> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <drupal6>, <html>, <java>, <javascript>, <php>, <posh>.

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.