PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming Meeting request Macros?

Reply

Meeting request Macros?

 
Thread Tools Rate Thread
Old 13-07-2005, 02:58 PM   #1
=?Utf-8?B?Qm9iIFNpc3Nvbg==?=
Guest
 
Posts: n/a
Default Meeting request Macros?


When a "Meeting Request" comes in, I want to run a VB script to perform a
number of things...

1) If it matches a template then.... (otherwise exit)
- Accept it and return the reply
- Label it
- change it to "optional attendee is not already
- Delete any reminder

has anyone already built such a script that I can modify (or something close)?


  Reply With Quote
Old 15-07-2005, 08:39 PM   #2
=?Utf-8?B?RXJpYyBMZWdhdWx0IFtNVlAgLSBPdXRsb29rXQ==
Guest
 
Posts: n/a
Default RE: Meeting request Macros?

I can take you part of the way, but you'll have to implement the part to
change the Appointment color label yourself (see the link in the code).
However, I'm not sure what you mean by "change it to "optional attendee is
not already"".

You can have this code fire automatically by creating a rule that runs on
incoming items that use the Meeting Request form and choose the option to run
a script.

Sub CustomMeetingRequestRule(Item As Outlook.MeetingItem)
' See:
' How to create a script for the Rules Wizard in Outlook:
' http://support.microsoft.com/defaul...B;en-us;q306108

AlterMeetingRequest Item
End Sub

Sub AlterMeetingRequest(Meeting As MeetingItem)
Dim objAssociatedAppointment As Outlook.AppointmentItem
Dim objReplyMeeting As Outlook.MeetingItem

Set objAssociatedAppointment = Meeting.GetAssociatedAppointment(False)
objAssociatedAppointment.ReminderSet = False

'Add code to modify label
'See:
' OutlookCode.com :: Outlook Code Samples :: Outlook Expert Techniques ::
Set color label on appointment:
' http://www.outlookcode.com/codedetail.aspx?id=139

Set objReplyMeeting =
objAssociatedAppointment.Respond(olMeetingAccepted, True, False)
objReplyMeeting.Send

Set objReplyMeeting = Nothing
Set objAssociatedAppointment = Nothing
End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
Try Picture Attachments Wizard for Outlook! http://tinyurl.com/ckytm
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/


"Bob Sisson" wrote:

> When a "Meeting Request" comes in, I want to run a VB script to perform a
> number of things...
>
> 1) If it matches a template then.... (otherwise exit)
> - Accept it and return the reply
> - Label it
> - change it to "optional attendee is not already
> - Delete any reminder
>
> has anyone already built such a script that I can modify (or something close)?
>
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off