Solved

Additional Response add in Resource mailbox

Posted on 2014-04-09
9
1,333 Views
Last Modified: 2014-08-13
Hello Team,

Can you please help me in this.

we have a request from Bluck mailbox that is Resource mailbox. in that automatic reply need to be set, that usually comes when anybody accept the meeting for that Resouurce mailbox.
So some additional message need to add in all mailboxes.. numbers are 100 mailboxes.

So please tell the automated way to do thisin one go

Thanks,
Andy
0
Comment
Question by:Addy Nadia
[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
  • 5
  • 4
9 Comments
 
LVL 5

Author Comment

by:Addy Nadia
ID: 39990635
I mean yo set :

Customize the Response Message for Resource Scheduling


For one mailbox i think we used this command :

Set-CalendarProcessing -Identity "Car 54" -AddAdditionalResponse:$true  -AdditionalResponse:"All requests for Car 54 are subject to approval."

If this correct, then what would be command if want to give the same to multiple Resource mailboxes
0
 
LVL 15

Expert Comment

by:jrhelgeson
ID: 39994328
It looks like you'd just change the text of "Car 54" to whatever the resource mailbox would be.

Do you have a list of the resource mailboxes?
0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 39995563
Yes, i have list of Resource mailboxes name and also the additonal message is not of single line.. its of 4 5 lines.

So i need the command so that it take the input of  Resource mailbox alias the message from the Text file..
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 15

Expert Comment

by:jrhelgeson
ID: 39998956
Is it the same 4-5 lines of text, but just the subject/object referenced is different?

This is going to require powershell scripting to get it done, which I'm working on.  In the meantime, what I can tell you is that you'll need to put all the data into a tab delimited file so that it looks like this:
Identity	Response
"Car 54"	"All requests for Car 54 are subject to approval."
"Car 55"	"All requests for Car 55 are subject to approval."

Open in new window


Easy way to do this is put all the info into an Excel Spreadsheet then export the spreadsheet to a .CSV file (text file).  Be sure to have the text encapsulated in quotes.
0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 39998971
Yes it the 4-5 lines of information mail that user want to send all users when they send the booking request..it is something likr instructions for the room

So i need command through which i can input the mailboxes name and the text file that contain the additional response...

Thanks for working on it..i appreciate and i hope u will help me in this.
0
 
LVL 15

Expert Comment

by:jrhelgeson
ID: 39999719
CSV File Layout must look like this when viewed in a text editor. The header line is important (Line 1 is the header line, and the values must match the $line.Variable used in the powershell command):
"Identity","Response"
"Car 54","All requests for Car 54 are subject to approval."
"Car 55","All requests for Car 55 are subject to approval."

Open in new window

Save the file above as .csv, and then run the following command (below):
$csv = Import-Csv c:\path\to\your.csv
foreach ($line in $csv) {
    Set-CalendarProcessing -Identity $line.Identity -AddAdditionalResponse:$true  -AdditionalResponse: $line.Response
}

Open in new window

0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 40000813
Still..some problem in this.

As i said..response messagebis not for single line it is of 5 lines response message..so gow can we proceed with that
0
 
LVL 15

Accepted Solution

by:
jrhelgeson earned 500 total points
ID: 40001602
You'll have to incorporate linefeed or newline escape characters into the text you are importing - these are usually `n  - that's the symbol that shares the ~key.  

This`nThat
will display as:
This
That


Also, in reviewing the code, you may need to encapsulate $line.Response in quotes, because it will strip the quotes out as it imports the CSV value.  You'll need to test that.

So change line 3 to be:
Set-CalendarProcessing -Identity "$line.Identity" -AddAdditionalResponse:$true  -AdditionalResponse: "$line.Response"

Open in new window

0
 
LVL 5

Author Comment

by:Addy Nadia
ID: 40001733
Ok i will test this nd let u know.
The csv file u suggested i will show you once i will run the command.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

728 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