Solved

Posted on 2014-04-09
1,333 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 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.

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

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 …
###### Suggested Courses
Course of the Month7 days, 14 hours left to enroll