Creating a calendar appt macro with several attendees

[kylster]

I'm trying to create a macro button on the Outlook toolbar that will open a
calendar appointment with today's date (no time range, or 8:00 am to 8:00 am)
and 5 specific people invited. So, anytime I wanted to meet with these 5
people, I just click the macro button and adjust the time. I'm lost on how to
create the code to open the calendar appointment and populate it with the 5
attendees and the default time. I'm running Office Pro 2003. Any help will be
greatly appreciated.

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/codedetail.aspx?id=88, but substitute this statement:

Set objOL = CreateObject("Outlook.Application")

with

Set objOL = Application

and comment out the Const and statements. You might also want to replace ..Send with .Display.

 

[kylster]

I'm 90% there... 3 add'l clarifications:

What is the syntax for entering more than 1 recipient?
Is there a way to set the focus after the appointment is generated to the
"Scheduling" tab?
Is there a "refresh" available? Because when I add 1 recipient, for some
reason, Outlook will not display the available calendar times of the
recipient, unless I manually add a recipient, then they all are displayed.

 

[Sue Mosher [MVP-Outlook]]

You can set the RequiredAttendees property to a semi-colon delimited string of recipient addresses.

There is no Refresh method.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[kylster]

Thanks for your expert assistance!!!

You can set the RequiredAttendees property to a semi-colon delimited string of recipient addresses.

There is no Refresh method.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54