Output information to outlook custom form

[avarusbrightfyre]

I have a database that tracks event information. We also track the information in an outlook calendar that has custom forms. The boss wants to use the calendar, but the logistical requirement mandates we use an access database to automate the paperwork process. What I specifically want is a way to fill out the information for the event in access, then export pieces of that information to a custom form in outlook. It would need to be able to find a specific entry already in the calendar and update the custom form.



Is this possible?

[June7]

Probably. This is called MS Office Automation. VBA code can be written that controls the interaction of the various MS Office Suite modules. I have automated Access, Excel, and Outlook E-Mail, but none of the other Office components. Start with this article http://msdn.microsoft.com/en-us/libr...ffice.11).aspx