Hi.
I am very much a beginner with MS Access and VBA. I am using V2003 for Access and Outlook. I have designed a custom Outlook form that is similar to a meeting request and published it to my calendar at IPM.Appointment.meeting1.
I have an onClick event procedure that I am using to call a standard meeting request. I am using the following code to do so:
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olAppointmentItem)
myItem.MeetingStatus = olMeeting
myItem.Subject = "Reference: "
myItem.Start = #9/29/2008 9:00:00 AM#
Set myRequiredAttendee = myItem.Recipients.Add("Mike Kagan")
myRequiredAttendee.Type = olRequired
myItem.display
End Sub
How do I change this to call my custom form?
Thanks!
I am very much a beginner with MS Access and VBA. I am using V2003 for Access and Outlook. I have designed a custom Outlook form that is similar to a meeting request and published it to my calendar at IPM.Appointment.meeting1.
I have an onClick event procedure that I am using to call a standard meeting request. I am using the following code to do so:
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olAppointmentItem)
myItem.MeetingStatus = olMeeting
myItem.Subject = "Reference: "
myItem.Start = #9/29/2008 9:00:00 AM#
Set myRequiredAttendee = myItem.Recipients.Add("Mike Kagan")
myRequiredAttendee.Type = olRequired
myItem.display
End Sub
How do I change this to call my custom form?
Thanks!