Color Category Access to Outlook

  • Posted
  • Proposals 3
  • Remote
  • #26452
  • Awarded
Excel Gurus ..
Basit A.Bryan Andrew R. have already sent a proposal.
  • 0

Description

Experience Level: Expert
I have an Access 2007 database pushing appointments to Outlook 2007. I want to set the color of the appointment using VBA. The appointment details are generated in Access and requires no additional user input after the details are entered in the system. All appointments are driven by data in the tables. Given certain criteria I want the appointment color category to change in Outlook. Access is sending the command but it appears Outlook is not receiving/processing the commands from walking through the code. I can categorize the appointments manually and the color categories do work. I have users in 3 sites so I need VBA to set the colors since I do not want to do this via manual settings.

The calendar is a shared calendar but it shouldn\'t make a difference. The appointments are posted to the shared or default folders depending on the code in VBA.

It could be a reference setting (am new to CDO and Outlook modelling) or the actual code.

Please let me know if you need any further detail.

Clarification Board

    There are no clarification messages.