dbTalk Databases Forums  

Adding Appointment to Outlook Public Folder

comp.databases.ms-access comp.databases.ms-access


Discuss Adding Appointment to Outlook Public Folder in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mal_lori@hotmail.com
 
Posts: n/a

Default Adding Appointment to Outlook Public Folder - 08-19-2005 , 06:09 PM






Hello,

I have basic code to Creat an Outlook appointment and add Access Data.
(code below)
This works to add appointments to the basic calendar in my user folder.
However I wish to add it to a Calendar that resides in Public folder.
Any advice or resources on how to do this?
The "address" is .... Public Folders...All Public
Folders...CommonRanchCalendar

And...if I can push my luck a little further.
How can I read/delete appointments in the same calendar through code.
I would want to limit what I delete to entries of a certain Category
(ie. "AccessAdded") although they will also have other categories
assigned to them.

Thanks in Advance for any help or pointers.

Mal.
=====
Existing Code to add basic Appointment.

Private Sub SndToOutlook_Click()
On Error GoTo Add_Err

'Add a new appointment.

Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Dim objRecurPattern As Outlook.RecurrencePattern

Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)

With objAppt
.Start = Me!ApptDate
.End = Me!ApptEnd
.AllDayEvent = True
.Subject = Me!ApptName
.Categories = "Retreat Groups" 'Check GroupID for CHR and
also add "Sponsored Retreat"
.Save
.Close (olSave)
End With

'Release the AppointmentItem object variable.
Set objAppt = Nothing

'Release the Outlook object variable.
Set objOutlook = Nothing

'Set the AddedToOutlook flag, save the record, display a message.
DoCmd.RunCommand acCmdSaveRecord
MsgBox "Appointment Added!"

Exit Sub


Reply With Quote
  #2  
Old   
pietlinden@hotmail.com
 
Posts: n/a

Default Re: Adding Appointment to Outlook Public Folder - 08-20-2005 , 02:02 AM






this is a bit of a dodge answer, but I would check two places for this:
the MS website or
www.slipstick.com - Sue Mosher's Outlook MVP site. If it's not there,
I'd be surprised.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.