Room Mailbox , Outlook import from excel

We want to create Room mailboxes for 12 conference rooms.  We already have a web base system that contains the meetings already setup but it is not an automatic system and it still requires some manual input.  We want  to create the room mailbox for these conference rooms but the problem is importing the current meetings already setup in the web base system.  We can have our DBA's to export this information into an excel spreadsheet but the problem is how to import these into the Room mailbox calender's.
hbpubAsked:
Who is Participating?
 
Will SzymkowskiConnect With a Mentor Senior Solution ArchitectCommented:
If you can have your DBA's export this to a CSV it is then pretty easy to import the info into the calendar. Do the following steps...

You need to have full access permissions on the mailbox to update the calendar this way...
- Open the CSV copy all fo the data
- Open Outlook
- Click the Calendar Tab
- Add the Room Mailboxes to your Outlook session
- Click the View Tab
- Click Change View button
- Change the View to "LIST" view
- Paste all of your records from the CSV file into the List view area

Hope this helps!
0
 
David LeeCommented:
Use Outlook's built-in import capability to pull the data in.  In order to give more specific instructions I need to know what version of Outlook you're using.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
hbpubAuthor Commented:
BlueDevilFan, We have outlook 2010.
0
 
David LeeCommented:
1.  Click File
2.  Click Open
3.  Click Import
4.  Choose Import from another program or file
5.  Click Next
6.  Select Microsoft Excel
7.  Click Next
8.  Select the calendar to import to
9.  Click Next
10. Depending on the layout of your spreadsheet you may need to "Map Custom Fields".  If that's the case, then do so.  Otherwise ...
11.  Click Finish
0
 
hbpubAuthor Commented:
Will try this and see if it works.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.