Results 1 to 2 of 2
  1. #1
    timg147 is offline Novice
    Windows XP Access 2002
    Join Date
    Aug 2010
    Posts
    1

    Update Outlook task from Access

    Hi All



    Not got a huge amount of experience with VBA. But here is what I am trying to do. I have a database to track warranty claims returned to our suppliers. Each claim has a sequential number. I have already inserted code so that when a claim is entered it sends a task to outlook with the suppliers name and claim reference in the Subject along with some standard text.

    Now what I want to do is to be able to update the task from access. I have a field that has the warranty status with a default value of "Pending". What I would like is if I update this field with directly in the table or through a form then I want the task status to change so that I dont get my automatic task pop up after the set period of time.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    as a last resort, what you can do to quickly figure stuff like this out is to write it in outlook itself where the intellisense can help you out with the library objects and properties and then simply transfer the code into access once you've established the outlook object from access's libraries

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Add task from Access to Outlook
    By Johan in forum Programming
    Replies: 1
    Last Post: 03-31-2010, 09:58 AM
  2. Outlook Form to Access problem
    By bearsgone in forum Import/Export Data
    Replies: 1
    Last Post: 02-04-2010, 11:14 AM
  3. Outlook to Access
    By Aubreylc in forum Import/Export Data
    Replies: 1
    Last Post: 01-25-2010, 09:37 AM
  4. MS-Access into Outlook - possible?
    By techexpressinc in forum Access
    Replies: 0
    Last Post: 01-09-2009, 01:44 PM
  5. Export Access reports/query results to Outlook Calendar/Task
    By kfinpgh in forum Import/Export Data
    Replies: 0
    Last Post: 02-22-2007, 01:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums