Notify calendar of other users

[Gerry Verschuuren]

I know how to notify my own Outlook calendar from Access through VBA. But is
it also possible to notify the calendar of other users on the same network? I
realize it goes against security, but other users may want to be notified.

How can this be done in VBA from Access?

Thanks a lot.

Gerry

 

[Dmitry Streblechenko]

"Notify" in what sense? Display a reminder?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Gerry Verschuuren]

Yes, exactly.

"Notify" in what sense? Display a reminder?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Dmitry Streblechenko]

Can you create meeting request and send it?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Gerry Verschuuren]

That's my problem. I can send a meeting date to my own calendar, but I don't
know whether I can send one to someone else's calendar. I doubt, since that
would be security break.

 

[Dmitry Streblechenko]

Create an AppointmentItem object, add the recipient
(AppointmentItem.Recipients.Add), call AppointmentItem.Send
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Gerry Verschuuren]

What would I type for Recipients??? A username, or what?

This is my code so far:
Sub OutlookCalendar(sSubject As String, dAlert As Date)
Dim oApplic As Outlook.Application, oAppoint As Outlook.AppointmentItem,
sRecip As String
Set oApplic = New Outlook.Application
Set oAppoint = oApplic.CreateItem(olAppointmentItem)
oAppoint.Subject = sSubject
oAppoint.Start = DateSerial(Year(dAlert), Month(dAlert), Day(dAlert)) +
TimeSerial(9, 0, 0)
oAppoint.ReminderPlaySound = True
'oAppoint.Save
sRecip = InputBox("Name of recipient")
oAppoint.Recipients.Add sRecip
If sRecip <> "" Then oAppoint.Send
oApplic.Quit
Set oApplic = Nothing
End Sub

 

[Dmitry Streblechenko]

Yes. name, e-mail address, etc. Whatever can be uniquely resolved to that
user's entry in GAL.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-