XOutItem.BusyStatus = xRg.Cells(I, 5).Value XOutItem.Duration = xRg.Cells(I, 4).Value XOutItem.Location = xRg.Cells(I, 2).Value Set xOutApp = CreateObject('Outlook.Application') VBA code: Create Outlook reminders from Excel spreadsheet Sub AddAppointments() Then copy below VBA code into the Code window. In the Microsoft Visual Basic for Applications window, click Insert > Module. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.ģ. You can change it to 1 (Tentative), 3 (Out of Office), 4 (Working elsewhere), or 5 (Free) as you need.Ģ. Note: For the busy status column, number 2 means that the reminder will be shown as Busy in your Outlook calendar. Create a worksheet contains the column headers and corresponding reminder fields as below screenshot shown.
If you want to create Outlook reminders from Excel, please do as follows.ġ. This article is talking about creating Outlook reminders based on data of Excel spreadsheet.Ĭrete Outlook reminders from Excel spreadsheet with VBA code How to create Outlook reminders from Excel spreadsheet?
