Exchange 2013 Giving one user access to 28 other users calenders. publishing editor rights ? in one go

I recommend you create a CSV file with all of the names of the users the one user needs access to.  Similar to this...

Alias,NAME_OF_USER_THAT_NEEDS_ACCESS
JDoe,Me
BDoe,Me
JSmith,Me
BSmith,Me

Select allOpen in new window

This command should add the permissions you need for the one user to access all of the calendars specified in the CSV file...

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User $_.NAME_OF_USER_THAT_NEEDS_ACCESS –AccessRights PublishingEditor }

Select allOpen in new window

However, if the one user already has permissions set and they need to be modified, you will use this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Set-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User $_.NAME_OF_USER_THAT_NEEDS_ACCESS –AccessRights PublishingEditor }

Select allOpen in new window

Let us know.

Hi Todd,

Thank you once again for the above information these are the users & this is what she needs.
Can you support with this please?.&should I start learning PowerShell & do you have any suggestions
Thank you for your support by the way its been invaluable


I need to be publishing editor to the following:

Amalia Khemet
Amy Farrell
Andrew White
Anna Holland
Caroline Barnet
Charlotte Hynes
Chris Bruce
Guy Sumaili
Jackie O’Rourke
Jack Lynch
Jake Fowler
Joanna Drake
Jordan Blake
Kiran Kaur
Kirsty Hull
Luke Guest
Matthew Redmond
Matthew Wallis
Meg Harris
Natasha Nabbijan
Nimerjeet Kaur
Raphael Sanglay
Rebecca Collins
Rebecca Rae
Shannon Barnes
Sophie Burgess
Stephanie Matthews
Tayo Omole
Victoria Davies

The CSV will look like the following.  Save as "Users.csv" on C: ...

Alias
Amalia Khemet
Amy Farrell
Andrew White
Anna Holland
Caroline Barnet
Charlotte Hynes
Chris Bruce
Guy Sumaili
Jackie O’Rourke
Jack Lynch
Jake Fowler
Joanna Drake
Jordan Blake
Kiran Kaur
Kirsty Hull
Luke Guest
Matthew Redmond
Matthew Wallis
Meg Harris
Natasha Nabbijan
Nimerjeet Kaur
Raphael Sanglay
Rebecca Collins
Rebecca Rae
Shannon Barnes
Sophie Burgess
Stephanie Matthews
Tayo Omole
Victoria Davies

Select allOpen in new window

Then run this command in the Exchange Management Shell...

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User "ENTER THE NAME OF USER THAT NEEDS ACCESS HERE" –AccessRights PublishingEditor }

Select allOpen in new window

After running the command, should you receive an error like this...

An existing permission entry was found for user: ...

You will need to run this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Set-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User "ENTER THE NAME OF USER THAT NEEDS ACCESS HERE" –AccessRights PublishingEditor }

Select allOpen in new window

If you want to see if the permissions were set properly, run this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Get-MailboxFolderPermission ($_.Alias + ':\calendar') }

Select allOpen in new window

Hope that helps.

Should I start learning PowerShell?

Yes. If that is what you want.

Do you have any suggestions?

Get yourself a lab server ... http://www.expta.com/2016/05/expta-gen7-home-lab-server-builds-and.html

Hi Todd,

Thank you for this information it is so helpful & supportive. Please would you mind having a look at the screenshots I've added when I run the first script via Exchange Management Shell I get an error message.

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User " Louise Lanahan  " –AccessRights PublishingEditor }

Can you help?
Hi-Todd.docx

Can anyone help

fantastic support