Access to Outlook Appointment

[Guest]

I am trying to add an Outlook calendar appointment from a form in access.
Once the form has been comleted I'd like specific fields from the form to
transfer over to outlook as an appointment. How do I do this? I don't know
much about VBA so I'll need help. Thanks for you help...

 

[Guest]

Try this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Arvin Meyer [MVP]]

A form and all the code you'll need are in my demo at:

http://www.datastrat.com/Download/OutlookAppointment.zip
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

I think I can use this and change the code around to my needs. However, it
does not mention anything about label coloring. Can this be done where
certain criteria means a certain label color?

 

[John Vinson]

I think I can use this and change the code around to my needs. However, it
does not mention anything about label coloring. Can this be done where
certain criteria means a certain label color?

Take a look at "Conditional Formatting" in the online help.

John W. Vinson[MVP]

 

[Guest]

John, that worked perfectly Thank you....

Take a look at "Conditional Formatting" in the online help.

John W. Vinson[MVP]