Creating an Outlook appointment

  • Thread starter Thread starter Michael D. Wallen
  • Start date Start date
M

Michael D. Wallen

I am able to create and Outlook appointmernt (as shown in
Microsoft Knowledge Base Article - 160502) but this
creates the appointment in myu own calendar. does anyone
know how to create an apointment in someone else's
calendar?
 
Michael, this is a newsgroup devoted to Microsoft Access. You should post
this question to microsoft.public.outlook.calendaring.

I'll tell you briefly that you'll have to have permission to create items on
the other user's calendar. If you do, you can go to File > Open > Other
User's Folder. Enter the name of the other user, and select their calendar.
When it opens, create an appointment in it as if it were your calendar.
 
I have used the following in Access 2000 and 2002 apps...

Dim objOApp As New Outlook.Application
Dim objAppt As AppointmentItem
Dim oExp As Outlook.Explorer
Dim objRecipient As Recipient
Dim strOptionals As String

Dim strAddressee As String
Dim strSubject As String
Dim lngDuration As Long ' represents duration of event in minutes/
database has it in hours.
Dim strLocation As String
Dim strAdditCases As String
Dim strAdditInfo As String

' Initialize selected variables
strAddressee = "(e-mail address removed)"
strSubject = "Appointment for your IRS Audit"
lngDuration = 90
strLocation = "IRS Office"
strAdditInfo = "They want you to be on time."

Set objOApp = New Outlook.Application
Set objAppt = objOApp.CreateItem(olAppointmentItem)
Set oExp = objOApp.Session.GetDefaultFolder(olFolderInbox).GetExplorer

With objAppt
.RequiredAttendees = strAddressee
.Subject = strSubject
.Importance = 2 ' high
.Start = Me!Date & " " & IIf(IsNull(Me!Time), " 8:00", Me!Time)
.Duration = lngDuration
.Location = strLocation
If Len(Trim(strAdditInfo)) > 0 Then
.Body = strAdditInfo
End If

.ResponseRequested = True
.Send
MsgBox "Item sent."
End With

hth,
 
DDM,

Respectfully disagree. I think this falls under the general area of
"Automation", which is definitely possible/doable with Access
 
what's with plonk!
Cheryl Fischer said:
DDM,

Respectfully disagree. I think this falls under the general area of
"Automation", which is definitely possible/doable with Access

--

Cheryl Fischer, MVP Microsoft Access



items
Click to expand...
 
Back
Top