Solved

Posted on 2014-04-09
1,086 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
Question by:Andy Navi
• 5
• 4

LVL 4

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 4 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 4 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 4

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 4

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

### Suggested Solutions

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…