Microsoft Access - Is there a way to have Access reports automatically emailed to you on a recurring basis

Hi,

Since my Excel keeps screwing up the conditional formatting for my report, I decided to write the report in Access. I am curious if there is a way to set up Access reports to be automatically emailed on a recurring basis. So let's say I want this report to be emailed weekly to someone, can I set that up in Access? Or is there a roundabout way of doing this?

Thank you!

If you can execute it via some sort of macro, then yes, I believe it is possible.  I don't use Microsoft Access but I believe this thread points at what you need:

http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/dd73fbd0-1d10-42a0-aa72-0ff9f8d48fe3/

on a somewhat more complicated note, but not really, once you do it

you can use dotnet code examples for emailing (there's many)\

and wrap it up in a com object

and once it is in a com object, you can call it from access as a createobject with no problem

I know that sounds complicated, but many machines already have .net 2.0 or at least 1.1 installed...

the only reason I say this is because way back in the asp day, I looked and looked for a free emailer
there's isn't one

I ended up using the one from evan's tech, which was ok, but it doesn't support SSL, but I didn't care... since I was using it internally to my own email server

there are others, but none free.... search on .net emailer

if you wanted, I would wrap one for you. It wouldn't take me very long, so I offer.

I sort of have to do it anyway.