Calling access functions from Outlook

[spizotfl]

Hi, I have a different take on the email thing. Basically what I want to do is setup a recurring task on the Outlook calendar, use it to call a function in Access that exports a report, and then email the report. I know I can setup a "shadow" database that, when opened, has a form that links to the tables in the real database and can call the function. I already know how to send the email and get the events in Outlook.

Basically I'm just wondering if it is possible to call the Access function directly from Outlook (not having much luck in the last couple of days finding a solution. Maybe I don't know the proper terminology for what I am trying to do.)

Thanks for the help....

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

 

[HarleyQuinn]

Can you not just reference the Microsoft Access X.0 Object Library from Outlook VBA and use that in a similar way to using the Outlook Library from Access?

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[spizotfl]

I am not quite sure how to do that, or if that would directly solve the problem. Could you elaborate some?

Thanks for the quick response

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

 

[HarleyQuinn]

You know how you can use Access VBA to expose the Outlook Object Model and make use of it's functionality (e.g. send an e-mail, extract data from folders etc.)? You can do that the other way round using Outlook VBA to expose the Access Object Model, and use it to perform the tasks you require Access to do in the same way.

Hopwe this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[spizotfl]

I'll take a look at it to see if I can figure it out.
Thanks for your time.

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut