+ Reply to Thread
Results 1 to 2 of 2

import/export calendar info between Outlook and Excel

  1. #1
    Registered User
    Join Date

    import/export calendar info between Outlook and Excel

    Hi all,

    I am importing/exporting calendar data between my Outlook calendar and an Excel (.csv) file. I would like to automate this process with macros, ideally run from Excel.

    The importing/exporting function is in Outlook. When I record a macro in Excel, it stops recording when I switch to Outlook. Outlook has macro functionality but no record option.

    Can anyone offer a suggestion or provide code that will enable this?

    Export Process
    File > Import/Export
    Choose an action to perform: Export to file
    Create a file of type: Comma Separated Values (Windows)
    Select folder to export from: Calendar
    Save exported file as: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
    Replace Existing file?: Yes
    Set Date Range 1/2/2008 and 30/12/2010

    Import Process
    File > Import/Export
    Choose an action to perform: Import from another program or file
    Select file type to import from: Comma Separated Values (Windows)
    File to import: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
    Options: Replace duplicates with items imported
    Select destination folder: Calendar

    The automation is complicated by the need to save and close the excel file prior to importing or exporting to/from it.

    Happy to elaborate further if required.

    Thank you in advance for any assistance.



  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Hello Heski,

    It is possible to automate the export/import process from Outlook to Excel and back. The downside is the Outlook import and export functions are not available outside of Outlook. The routines would have to be rewritten in VBA. To do so, requires a solid knowledge of both programs and their VBA routines. I don't mean to dash your hopes. Given the complexity and degree of expertise needed, I am not sure you will find someone willing to do this level of work for free.

    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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