Color Category Access to Outlook
- or -
Post a project like this5069
£250(approx. $313)
- Posted:
- Proposals: 3
- Remote
- #26452
- Awarded
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.
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.
Michael R.
0% (0)Projects Completed
2
Freelancers worked with
3
Projects awarded
33%
Last project
21 Jan 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies