In Outlook 2007 and older, it’s at Tools, Macro Security. To check your macro security in Outlook 2010 or 2013, go to File, Options, Trust Center and open Trust Center Settings, and change the Macro Settings. '.Send ' hit the send button yourself to avoid Select names dialogįirst: You will need macro security set to low during testing. '.End = xlSht.Cells(iRow, 6) + xlSht.Cells(iRow, 8) Start = xlSht.Cells(iRow, 5) + xlSht.Cells(iRow, 7) Set objAppt = Application.CreateItem(olAppointmentItem) Set xlApp = CreateObject("Excel.Application") ' Possible Values for Reminder Field is :'No Reminder','0 Minutes','1 Day','2 Days', '1 Week' ' Worksheet format: Subject, Location, Required Invitees, Categories, Start_Date, End_Date, Start_Time, End_Time, Reminder, Duration, Optional Attendees, Resource If we use Set xlApp = New Excel.Application a reference would be required.
Add optional attendees in outlook for mac code#
This makes the code a little more portable, as the user doesn't have to set the reference before using the code. If you just want to create appointments, remove the lines that apply to myAttendee and the line that sets the meeting status.īecause we're using Set xlApp = CreateObject("Excel.Application") we don't need to set a reference to Microsoft Excel Object Model in the VB Editor's Tools, References dialog. Avoid it by clicking the Send button yourself, after the macro creates all of the meeting requests.
Note: when you have more than one attendee, the name resolution dialog may come up when you use.
Save the workbook as either a CSV or as a native Excel (*.xlsx) file. Create one row for each meeting, using a semicolon as the delimiter if you have more than one attendee per meeting.
0 kommentar(er)
