Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Montreal, Quebec
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel linking with Outlook (XP)

    A user in my office (law firm) would like to create a timetable in Excel in which a column would be dedicated to dates (i.e. 10/20/05 for October 20, 2005). Is there a way, either by way of a macro or something else entirely, to make sure that, on the date in question, she would get a reminder in Outlook (either a task or calendar reminder).

    All suggestions are welcomed! <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Excel linking with Outlook (XP)

    I'm guess that the reason that she doesn't want to do this in Outlook is that she doesn't want to clutter her real calendar.
    Just a note - you can make additional copies of the outlook calendar and store whatever you want in them.
    This is way simpler that what you are proposing to do.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Location
    Montreal, Quebec
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel linking with Outlook (XP)

    I thought of that as well however she really needs Excel for her timetable as she needs to use some of its database functions. The idea is that she doesn't want to put everything in Excel and then go in Outlook and manually input the dates again.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel linking with Outlook (XP)

    If she needs to do database-like things, she could use Access. It is possible to link the Outlook calendar as a table in Access, and build queries, forms and reports based on this table.

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Location
    Montreal, Quebec
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel linking with Outlook (XP)

    Although I think that's a great idea (thanks for the tip I will probably use that for my own stuff!) she, the lawyer, does not know Access (and doesn't want to). We really must stick with Excel.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel linking with Outlook (XP)

    You'll need to use Automation to control Outlook from Excel. See the series of articles that begins at Automating Outlook with Excel by Excel MVP Dick Kusleika.

  7. #7
    New Lounger
    Join Date
    Jun 2002
    Location
    Montreal, Quebec
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel linking with Outlook (XP)

    Thanks! Sounds like it's what I need!

Posting Permissions

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