Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access - Outlook Interaction (2000)

    First time using this forum, so lets see if I get lucky! <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

    I'm currently using an MS Access database to record all incoming calls to the office and track the progress of resulting tasks. Now I want to improve this database, linking up with MS Outlook 2000.
    Is it possible to:
    (1) Link up to a contacts list within Outlook and both read and write to it from within Access?
    (2) Issue MS Outlook Tasks to various people from within Access?

    Is this possible? Are there any AddsIn or Modules available? I suppose I'm looking for a two way link between Access-Oulook similar to that of Word-Excel!

    All help gratefully recieved. Cheers,
    Mark <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access - Outlook Interaction (2000)

    Yes, it is possible to work in Access and have it affect Outlook. We have done the task thing for several clients and it seems to work fairly well, though it generally wants to create a task for the user account that is running Access at that point. So you have to do a task request, and there are some issues with that, but it can be made to work reasonably well. Working with contacts is stickier as some info is not available (even though you can see it in Outlook), and the data structure is not great so requests that get lots of contacts is pretty slow. What we chose to do in the one case we worked on was to actually store data in Access and then delete and add a new contact if we edited that record. It was ugly, but it worked. We haven't tried it with Office XP, so things may be a bit better there (except for the dreaded security features). Try searching the Outlook forum as well as this forum on Outlook and Automation. Good Luck!
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access - Outlook Interaction (2000)

    Have a look at <A target="_blank" HREF=http://www.helenfeddema.com/CodeSamples.htm>Helen Feddema's site</A>
    Maybe you find something useful to start.
    Francois

Posting Permissions

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