creating actions in office programs

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have built a large directory access database for my
company. I realized one day that it would be cool to have
the display map button in Outlook in my Access database
that would collect the address info on the screen and
pull up Microsofts maps, just like Outlook does in a
Contact.

I have knowledgeable friend that said I can copy classes
from outlook into Access? Is he right, if so how do I do
this. Or if there is another way - please give me some
hints?!?!?!?!?!

: )
Thanks
 
You can use the Outlook object model in Access VBA code, you can't
import Outlook classes as such as standalone objects. The only access
to the Map button would be by getting the CommandBarButton that
corresponds to that button and calling its Execute method.

A much better way would be to use an Internet control in your Access
code and supplying that control with an URL to a mapping Web site.
There are a number of posts and threads in the
microsoft.public.outlook newsgroup that deal with the URLs used by the
Map button that would provide examples of what you'd have to put into
your code as the URL for the Internet control.
 
Back
Top