Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    50

    Unanswered: outlook calendar from Access

    Hi,

    I have a function that adds an appontment to my default calendar. This isgreat, but I really need to add it to either a brand new calendar or an existing shared calendar. I'll show you my existing code below, hopefully it's a simple change!

    TIA,
    Joanne

    ' Add a new appointment.
    Dim outobj As Outlook.Application
    Dim outappt As Outlook.AppointmentItem
    Set outobj = CreateObject("outlook.application")

    Set outappt = outobj.CreateItem(olAppointmentItem)
    With outappt
    .Start = Now
    .Duration = 60 'in minutes!
    .Subject = "Test Subject"
    .Body = "Test Notes section"
    .Location = "PlyMtg"
    .ReminderMinutesBeforeStart = 8
    .ReminderSet = True
    .Save
    End With
    ' Release the Outlook object variable.
    Set outobj = Nothing
    MsgBox "Appointment Added!"

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Hi Jill,

    Maybe have a look at Sue Moshers' site ~(Think someone else runs it now)

    OutlookCode.com - Developer Learning Center for Microsoft Outlook

    Also, I would recommend her book -

    Amazon.com: Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators: Sue Mosher: Books

    For all things Outlook...
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Jun 2008
    Posts
    50
    Thanks, I'll take a look. however, I've found that most examples only show how to connect to the default calendar.

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    The book will explain how to do this and it does depend on a number of factors - what sort of environment you are working in exchange or not, whether it is a calendar in the default mail store etc. I will see if I have any links and post as soon as I get the chance.

    Guessing you have to itterate through each calendar in the default information store to get a handle on the one you wish to reference.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Jun 2008
    Posts
    50
    Thanks, I appreciate it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •