How To Add A Calendar In Outlook Instantly - How Do I Add Another Calendar To My Outlook?

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.

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