View Single Post
 
Old 12-22-2008, 12:19 PM
sshr sshr is offline
Novice
 
Join Date: Dec 2008
Posts: 1
sshr is on a distinguished road
Lightbulb Automatically Add Recipients to Meeting Requests

I created a custom Meeting Request form where users and select to request certain setups for conference rooms. Depending on what they have selected, I want to send an email automatically to the Service Center so that they also get a meeting request and they can set up the conference room as requested. Right now, I am adding the email address inside the Item_Send() function in VBA code:

Function Item_Send()
Set objPage = Item.GetInspector.ModifiedFormPages("Services")
If certain checkboxes are selected
Item.Recipients.Add("ss@somewhere.com")
End If
Item.Recipients.ResolveAll
End Function

The current problem I have is that if somebody makes an update to the meeting request and resends it, the email address gets added again. Although only one email gets sent out, the participant-list will have two entries for the service center email address. So I am trying to come up with the code to first check and see if the service center email address is already there as a recipient and only add it if it is not. Since I am new to this any help is greatly appreciated. Thanks.
Reply With Quote