Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2430
  • Last Modified:

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.
1
hbpub
Asked:
hbpub
1 Solution
 
Will SzymkowskiSenior 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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now