Import Excel Calendar Of Events Into Outlook How To Import A

In this article I will explain to you about how to import a calendar from Excel to Outlook.

Microsoft access can import data from Microsoft Excel and you can even export data to Excel.

In this article, you will know about how to import a Calendar from Microsoft Excel to Outlook.

Why do we import a Calendar from Microsoft Excel to Outlook It seems little bit obvious to transfer a Calendar from Excel to Outlook when you have only one or two future appointments because it is very simple to enter those details into Outlook itself.

What if you have more appointments and if you need to send that information to your employees by email and so you need to either retype entire details or you should export it into outlook from Excel.

But it is easy to enter such information in Excel than to enter in Outlook.

Prerequisites to create a Calendar in Excel To create a Calendar Template in Excel, first you need to know the common attributes an Excel Calendar will provide as default.

I will list all the basic attributes of an Excel Calendar below.

Subject: This information will be shown in your Outlook Calendar Star Time Start Date End Time End Date Location: This field gives information about the location of the appointment.

All Day Event: YesNo Reminder INOFF: YesNo Reminder Date: Reminder Time: Category: This gives appointment category Description: This gives detailed description about the appointment.

Private: YesNo Creating a Calendar Template in Excel Creating a template for calendar that can be uploaded to Outlook is bit sophisticated.

But you need to choose the list of attributes which are necessary to upload with the Email.

Import Excel Calendar Of Events Into Outlook Update The Calendar

Control Tab Control tab is having all the dropdown menus details which are necessary to update the calendar table.

Control tab is having all the information that is used to create dropdown menus in Update tab.

Below is a detailed description of how to create a Calendar in Excel.

Open Microsoft Excel and open new worksheet and save this worksheet as calendar.xls.

It is mandatory to save the file with.xls extension.

Select anyone tab and right click on it and rename that tab into Control tab.

As show from right side picture, enter All Day Event in cell B3.

Then highlight both B4 and B5 cells.

Enter Categories in cell E3.

Then enter all the categories which are used in Outlook into cells starting from cell E4.

Upload Tab Under this tab you can enter your information into Excel Calendar.

The mandatory fields that should update are start date, start time, end date, end time and all day events.

If it is necessary to add other fields then you can include those fields.

As shown in left picture, enter the title as Calendar Template in cell A1 and make it in bold format.

Enter all the relevant information in the fields starting from row 4.

Use the start date and end date columns as D5 and E27.

Use the start time and end time columns as F5 and G27.

Click on H5:H27 tab and then click on Data Validation then change it to dropdown list.

Select A4 to I27 and type upload in it.

Import the created Calendar into Outlook At this stage we are ready with calendar template and so you can copy or enter details about an appointment.

Import Excel Calendar Of Events Into Outlook For Mac