+ Reply to Thread
Results 1 to 2 of 2

Outlook Calendar Appointments

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    anamosa, iowa
    MS-Off Ver
    Excel 2007
    Posts
    34

    Outlook Calendar Appointments

    I use the following code to create appointments in my Outlook calendar. I have 5 other calendars that I created in Outlook for my different departments. How can I add the appointments to a specific calendar rather than the Main(default) calendar?

    Dim Mail_Object, Mail_Single As Variant
    Dim myoutlook As Object
    Dim myapt As Object

    On Error Resume Next
    Const olAppointmentItem = 1
    Const olBusy = 2
    Const olMeeting = 1
    Set myoutlook = CreateObject("Outlook.Application")
    Set myapt = myoutlook.CreateItem(olAppointmentItem)
    With myapt
    'This is where I have all the appointment info.
    I removed it, as it is not the part of code in question
    and to save space in this post because I use a lot of
    "IF/ANDs" to determine the appointment info.
    End With
    Set myoutlook = Nothing
    Set myapt = Nothing

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Outlook Calendar Appointments

    try looking here
    http://www.slipstick.com/developer/c...eadsheet-data/
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook appointments VBA
    By sara1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2015, 07:26 AM
  2. [SOLVED] Calendar appointments in Outlook via VBA
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2013, 08:11 AM
  3. [SOLVED] Excel Macro/VBA to Automate Outlook Calendar Appointments
    By LitParalegal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2012, 04:20 PM
  4. Mail merge: Converting Outlook calendar appointments into Invoices in Word
    By watfordo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2011, 12:39 PM
  5. Problems with excel an calendar and outlook appointments
    By boemboem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2008, 04:42 AM
  6. [SOLVED] Appointments from Excel into Outlook Calendar
    By Sh0t2bts in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2006, 11:20 AM
  7. [SOLVED] Creating Calendar appointments
    By Andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2005, 08:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1