- #OUTLOOK 2016 MEETING ATTENDEES UPDATE#
- #OUTLOOK 2016 MEETING ATTENDEES CODE#
- #OUTLOOK 2016 MEETING ATTENDEES SERIES#
If you want to include other contact fields in the printout, you can do a lookup of the contact then add any contact field to the string stored in objAttendeeReq and objAttendeeOpt as seen in the snippet below.īecause the attendee's name may include the email address in Fullname format, I'm using just the email address in the search query. ListAttendees.Body = strCopyData & vbCrLf & strCount
Set ListAttendees = Application.CreateItem(olMailItem) StrCount = "Accepted: " & ia & vbCrLf & _ VbCrLf & objAttendeeOpt & vbCrLf & "NOTES " & vbCrLf & strNotes VbCrLf & vbCrLf & "Required: " & vbCrLf & objAttendeeReq & vbCrLf & "Optional: " & _ "Location: " & strLocation & vbCrLf & "Start: " & dtStart & vbCrLf & "End: " & dtEnd & _ StrCopyData = "Organizer: " & objOrganizer & vbCrLf & "Subject: " & strSubject & vbCrLf & _ ObjAttendeeOpt = objAttendeeOpt & objAttendees(x).Name & vbTab & strMeetStatus & vbCrLf ObjAttendeeReq = objAttendeeReq & objAttendees(x).Name & vbTab & strMeetStatus & vbCrLf If objAttendees(x).Type = olRequired Then If objAttendees(x).Name objOrganizer Then Select Case objAttendees(x).MeetingResponseStatus
#OUTLOOK 2016 MEETING ATTENDEES CODE#
MsgBox "This code only works with meetings." Set objApp = CreateObject("Outlook.Application") The total counts of accepted, declined, tentative, and no response is added to the list. Then select or open a meeting you organized and run the macro to create a message containing the meeting details. Get the GetCurrentItem function from Outlook VBA: work with open item or selected item and paste it at the end of the module.
Copy this code and paste it into the Module. Right click on the Project1 in the left pane and choose Insert > Module.
To use, open Outlook's VBA Editor by pressing Alt+F11. See More Information for links to VBA code samples that send the information to Word or Excel.ĭon't forget to adjust your macro security settings to allow macros to run! Get Meeting Attendee List Macro They can rejoin if they still have the meeting invitation.This code sample gets the appointment details and attendees (along with their responses) and inserts it into a new Outlook message form, which you can print, send or copy the data for use in other applications. The attendee is removed from the meeting. Right-click the name of the person you want to remove. In the meeting window, click the Participants icon to see all of the attendees. You can also remove an attendee from an online meeting scheduled in Outlook and running in Skype or Teams when the meeting is in progress Remove an attendee from an ongoing online meeting in Skype or Teams
#OUTLOOK 2016 MEETING ATTENDEES UPDATE#
If you send the update only to added or deleted attendees, other people aren’t notified about the updated information. When you send the update, Outlook asks you to choose whether to send the update to everybody or only to those affected by the change. If you're using the Scheduling Assistant, in the All Attendees list, clear the check box next to the name of the person you want to remove. You can delete a person from the To line of the meeting request, or use the Scheduling Assistant from the Meeting menu.
#OUTLOOK 2016 MEETING ATTENDEES SERIES#
If it’s a recurring meeting, you can choose whether you want to edit the entire series or only one occurrence of the meeting. If you've created a meeting in Outlook, and one of the meeting attendees no longer needs to attend, you can remove them from the meeting request.įrom the calendar, open the meeting invitation you want to edit.