Excel VBA Outlook Calendar – Bulk Upload Tasks
Easy trick on how to add a Calendar Item in Outlook from list of reminders/appointments in Excel.
Manually creating big list of calendar appointments in Outlook is a time consuming task. This article explains about automating this task with a simple vba code.
Lets see how to Export and Import tasks between Outlook and Excel.
Add Appointments To Outlook Calendar – From Excel
Create a new Excel workbook with below header in Sheet1 & add some sample appointments.
Columns 1 – 5 : “Subject”, “Location”, “Start Date/Time”, “End Date/Time”, “Reminder (in Seconds)”.
Excel VBA Outlook Calendar - Add Appointment Items1234567891011121314151617181920212223242526272829Private Sub Add_Appointments_To_Outlook_Calendar()'Include Microsoft Outlook nn.nn Object Library from Tools -> ReferencesDim oAppt As AppointmentItem, olApp As Object, iRow As Double, sSubj As StringiRow = 2Set olApp = Outlook.ApplicationsSubj = ThisWorkbook.Sheets(1).Cells(iRow, 1)'Loop through entire list of Reminders to be addedWhile subj <> ""Set oAppt = olApp.CreateItem(olAppointmentItem)With oAppt.Subject = sSubj.Location = ThisWorkbook.Sheets(1).Cells(iRow, 2).Start = ThisWorkbook.Sheets(1).Cells(iRow, 3).End = ThisWorkbook.Sheets(1).Cells(iRow, 4).ReminderMinutesBeforeStart = ThisWorkbook.Sheets(1).Cells(iRow, 5).AllDayEvent = True.SaveEnd WithiRow = iRow + 1sSubj = ThisWorkbook.Sheets(1).Cells(iRow, 1)WendMsgBox "Reminder(s) Added To Outlook Calendar"End Sub
- Enter list of appointments in sheet for above fields.
- Press Alt+F11 to get VB editor.
- Include ‘Microsoft Outlook Object Library‘ from Tools -> References.
- Copy paste the below code.
- Execute the code by pressing F5.
Once the code is executed, the reminders will be added to the Outlook Calendar. Open Outlook calendar & verify that the entries are added correctly.
If you have a very big list of items to be added to Calendar, then this automation will be very useful.
How to Add Calendar Item to Outlook?
- Open Calendar in Outlook
- Choose the date to add appointment or task.
- Enter Subject, Location, Start/End Time, Description.
- Click Invite Attendees to send Meeting Invite to recipients.
- Adjust recurrence detail.
- Click Save/Send to finish.
If you have added any invitees, then Outlook will send the Meeting Invite to all recipients. If it is a reminder item for self, this will be saved in your Calendar.
Download Calendar Appointments to Excel
To fetch Appointment details from Outlook Calendar to Excel, there is two methods. You can use either the built in Export Option or using macro.
Both the tricks are explained in this article.
Topics Related to Excel Calendar Option:
How to Add a Calendar in Outlook? – Excel VBA Outlook Calendar