Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Outlook 97 to Access 97

    I have a customer who wants their employees to submit a Help Desk request via an Outlook form (because everyone has Outlook and not everybody has Access). I then want this info that will already be in fields to get dumped into Access so we can create Work Requests, To Do lists, etc. Any ideas?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts

    Re: Outlook 97 to Access 97

    The method you are describing actually sounds like one of the more difficult ways to collect the information. I envision a PC running Outlook with an unattended mailbox and when a message comes in it runs a special rule and stuffs the data into Access. Or you could send the message to a human and have her or him run a procedure to move the data from one place to the other. The problem with these approaches is making sure you get all the data you need from the user - the front end validation - and the limitations of Outlook 97.

    Other options include:
    (1) create a front end using VBA in Word or Excel
    (2) put a form on an intranet server
    (3) write a stand-alone application

    These options would allow users to append directly to the database - no Access needed, just DAO or ADO. And the forms can have more sophisticated prompting and error checking.

    But someone who knows how to script forms in Outlook 97 and to tap into messages using Access 97, might well tell me I'm missing something obvious.

Posting Permissions

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