Excel VBA Outlook Calendar – Bulk Upload Tasks
How to add a calendar in outlook, The easy trick on how to add a Calendar Item in Outlook from a list of reminders/appointments in Excel how to add a calendar in outlook.
Manually creating a big list of calendar appointments in Outlook may be a time-consuming task. This article explains about automating this task with an easy VBA code.
How do I add another calendar to my Outlook?
Let’s see how to Export and Import tasks between Outlook and Excel.
how to add a calendar in outlook -Add Appointments To Outlook Calendar – From Excel
Create a new Excel workbook with the below header in Sheet1 & add some sample appointments.
Columns 1 – 5: “Subject”, “Location”, “Start Date/Time”, “End Date/Time”, “Reminder (in Seconds)”.
- Enter a list of appointments in the sheet for the 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.
Private Sub Add_Appointments_To_Outlook_Calendar()
‘Include Microsoft Outlook nn.nn Object Library from Tools -> References
Dim oAppt As AppointmentItem, olApp As Object, iRow As Double, sSubj As String
iRow = 2
Set olApp = Outlook.Application
sSubj = ThisWorkbook.Sheets(1).Cells(iRow, 1)
‘Loop through entire list of Reminders to be added
While 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
.Save
End With
iRow = iRow + 1
sSubj = ThisWorkbook.Sheets(1).Cells(iRow, 1)
Wend
MsgBox “Reminder(s) Added To Outlook Calendar”
End Sub
Once the code is executed, the reminders will be added to the Outlook Calendar. Open Outlook calendar & verify that the entries are added correctly how to add a calendar in outlook.
If you’ve got a really big list of things to be added to Calendar, then this automation are going to be very useful.
How to Add Calendar Item to Outlook?
- Open Calendar in Outlook
- Choose the date to add an 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.
See Also – HyperX’s Pulsefire Haste is a lightweight gaming mouse covered in holes
Download Calendar Appointments to Excel
how to add a calendar in outlook – To fetch Appointment details from Outlook Calendar to Excel, there are two methods. You can use either the built-in Export Option or using a macro.
Both the tricks are explained in this article.
Official Link to Purchase MS Office 360