Setting up meetings or booking conference rooms aren’t necessarily activities you enjoy. Outlook has ways to handle this for you, so don’t hesitate to learn how to use Outlook Scheduling Assistant.
Let’s assume you’ve been tasked with planning a meeting with several attendees. You set up the meeting and send it out without having any way to make sure everyone can actually come. What happens next?
Instead of ending up with several responses telling you that either they are unavailable or would like to propose a new time, let Scheduling Assistant do the heavy lifting.
How can I use Outlook Scheduling Assistant?
1. Discover Outlook Scheduling Assistant
- In Outlook, click Calendar in the bottom left corner of the screen.
- From the Home tab, at the top left of the screen, click on the New Meeting icon.
- Select New Meeting from the drop-down list.
- A new window appears next. From the Meeting tab, select Scheduling Assistant.
- Now, it’s time to enter a description of the meeting in the Title text box.
- In the Required text box, enter the email address of each attendee required to attend the meeting.
- In Outlook 2016 and 2013 instead, enter the attendees in the To field and the conference room you want to book under the Resources field.
- Also enter the Start and End times. From the Suggested Times list, choose the desired time or make adjustments to your time and date to find a time that works for everyone.
- In the Location text box, enter the address or room number where the meeting will be held.
- Up next, in the Message area, enter any notes your attendees will need to know before the meeting such as any special instructions or the Agenda.
- When you’re done setting up the meeting, click Send.
Note: When you send a meeting invitation in Outlook, the invitation includes a request for a response and gives the recipient the option to suggest a new time for the meeting.
2. How can I export Outlook Scheduling Assistant to Excel?
- Open Outlook and go to File.
- Go to Open & Import and the Import/Export wizard will open.
- Select Export to a file.
- Click Next to continue.
- In the Export to a File dialog, select Comma Separated Values.
- Then, click Next.
- Now, select Calendar from Outlook Data File.
- Click Next once more.
- When the Export to a File dialog displays, click the Browse button. Here you can select the file’s destination.
- Choose the destination where the file can be saved. Name the file and click OK to close the dialog.
- When the Export to a File dialog displays again, hit Next to continue.
- Then, click Finish to export your Outlook calendar.
- Outlook exports the specified calendar as a CSV file. Open it with Microsoft Excel, and then save the file as workbook.
If you’re looking for a way to share your Outlook Scheduling Assistant with others, you can export your calendar to Excel, and then import it into others’ Outlook calendar folder by following the above steps.
3. How can I set a time zone for a meeting or appointment in Outlook?
Note that when you create such new meetings or appointments, Outlook uses the default time zone in your Outlook preferences for Calendar. This doesn’t mean that you cannot specify a different time zone for an event as you are creating it.
To display the Time zone selector, on either the Organizer Meeting tab or the Appointment tab, click Time Zones. There, specify the precise time zone of the event.
If older versions for Outlook for Mac can display only two time zones, in the most recent version of Outlook for Mac for Office 365 and Outlook 2019 no less than three separate time zones can be displayed in the Calendar.
This article showed you how to use Outlook Scheduling Assistant, export it to Excel, and set the time zone for a meeting or appointment in Outlook. Easy, right?
Just remember that instructions apply to Outlook for Office 365, Outlook 2019, Outlook 2016, and Outlook 2013.