![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hello,
I have an access database that I'm taking form information and inserting it into a outlook meeting request. I've that that working, thanks forum posts here. But now I'm trying to create two more buttons on that form that allow the user to update or cancel the meeting request that has already been created. I'll give you the code I have for creating the meeting request: ______________________________________ Private Sub CmdCancelAppointment_Click() Dim objOApp As New Outlook.Application Dim objAppt As AppointmentItem Dim oExp As Outlook.Explorer Set objOApp = New Outlook.Application Set objAppt = objOApp.CreateItem(olAppointmentItem) Set oExp = objOApp.Session.GetDefaultFolder(olFolderInbox).Ge tExplorer With objAppt ..RequiredAttendees = [Forms]![frmEvent_Part1_Details]![Audio Emails Combined] & ";" & [Forms]![frmEvent_Part1_Details]![Lighting Emails Combined] & ";" & [Forms]![frmEvent_Part1_Details]![Projection Emails Combined] & ";" & [Forms]![frmEvent_Part1_Details]![StageHands Emails Combined] & ";" & [Forms]![frmEvent_Part1_Details]![Camera Emails Combined] & ";" & [Forms]![frmEvent_Part1_Details]![Other Emails Combined] ..Subject = [Forms]![frmEvent_Part1_Details]![Name of Event] & " " & [Forms]![frmEvent_Part1_Details]![Part Date Text] ..Importance = 1 ' Normal ..Start = [Forms]![frmEvent_Part1_Details]![Part Date Text] & " " & [Forms]![frmEvent_Part1_Details]![Part Start Time Text] ..Location = [Forms]![frm All Events]![Part 1 Location] ..Body = [Forms]![frmEvent_Part1_Details]![Additional Part Notes Text] ..MeetingStatus = 1 ..ResponseRequested = True ..Save ..Send MsgBox "Event Cancellation Sent." End With Exit_btnSendItem_Click: Set objOApp = Nothing Set objAppt = Nothing Set oExp = Nothing Exit Sub End Sub __________________________________ Thanks in advance. -- Joshua |
Ads |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I update a meeting request without emailing all attendees | Renishug | Outlook - Calandaring | 0 | February 20th 08 11:03 AM |
Send Update for Meeting Request Not Functioning Properly | Hilary | Outlook - Calandaring | 4 | June 30th 07 03:20 PM |
Unable to send an update on cancellation of meeting request | yadav | Outlook - Calandaring | 0 | February 13th 07 07:35 PM |
Cancel a meeting resource without sending update to all | sitkacat | Outlook - Calandaring | 4 | October 24th 06 12:53 PM |
add attachment to a meeting request and send update | Yolaine | Outlook - Calandaring | 0 | July 20th 06 01:20 PM |