Solved

Posted on 2014-04-09
1,123 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
• 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 process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
how to add IIS SMTP to handle application/Scanner relays into office 365.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…