Sue's vaction request form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dp - 12 Jan 2004 21:41 GMT

I'm trying to modify Sue's vacation request form to CC another user once the
manager has approved or disapproved the request. I've seen in another post
where Sue says to add an "Item_CustomAction event handler" but I'm not sure
what to put in there. This is what I have so far.

Function Item_CustomAction(ByVal Action, ByVal NewItem)

End Function

Any help would be greatly appreciated.

Reply to this Message

Sue Mosher [MVP] - 12 Jan 2004 22:15 GMT

Action is the custom action from the (Actions) tab. NewItem is the new item
that action creates. If you want to add code, use a Select Case statement to
handle each action:

Function Item_CustomAction(ByVal Action, ByVal NewItem)
Select Case Action.Name
Case "Approve"
' your approval code goes here
Case "Deny"
' your denial code goes here
End Select
End Function

The vacation request form already has examples of this.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I'm trying to modify Sue's vacation request form to CC another user once the
> manager has approved or disapproved the request. I've seen in another post
[quoted text clipped - 6 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

dp - 15 Jan 2004 19:58 GMT

Thank you for your reply Sue, I was able to get the CC to work. I just
added the CC field to the form and then edited it with the e-mail address
that I wanted. I'm assuming behind the GUI it did what you had suggested.
I do have another question but I'll create a new post.

Thanks again.

> Action is the custom action from the (Actions) tab. NewItem is the new item
> that action creates. If you want to add code, use a Select Case statement to
[quoted text clipped - 23 lines]
> >
> > Any help would be greatly appreciated.

Reply to this Message

Sue Mosher [MVP] - 15 Jan 2004 20:41 GMT

Note that, unless you're using a different form to handle the management
responses, the cc will go with the original request, as well as the
response.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Thank you for your reply Sue, I was able to get the CC to work. I just
> added the CC field to the form and then edited it with the e-mail address
[quoted text clipped - 33 lines]
> > >
> > > Any help would be greatly appreciated.

Reply to this Message

dp - 15 Jan 2004 22:49 GMT

Yeah the CC is just on the Approval form.

> Note that, unless you're using a different form to handle the management
> responses, the cc will go with the original request, as well as the
[quoted text clipped - 38 lines]
> > > >
> > > > Any help would be greatly appreciated.

Reply to this Message