Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

Posted on 2014-04-09
Medium Priority
1,506 Views
Hello Team,

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
[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
• 5
• 4

LVL 5

Author Comment

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 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 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 LVL 15 Expert Comment 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."  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 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 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."

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
}

0

LVL 5

Author Comment

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

jrhelgeson earned 1500 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.

ThisnThat
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"

0

LVL 5

Author Comment

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

Question has a verified solution.

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

Know the reasons and solutions to move/import EDB to New Exchange Server. Also, find out how to recover an Exchange .edb file and to restore the file back.
On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
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 show how to create a transport rule 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 Mail Flow >> Rules tab.:  To cr…
###### Suggested Courses
Course of the Month11 days, 9 hours left to enroll