Creating an Outlook appointment

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?
 
D

DDM

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.
 
C

Cheryl Fischer

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 = "[email protected]"
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,
 
C

Cheryl Fischer

DDM,

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

bong

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
 
Top