Automate Sending Reports from Access

%3CLINGO-SUB%20id%3D%22lingo-sub-2671718%22%20slang%3D%22en-US%22%3EAutomate%20Sending%20Reports%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2671718%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20automate%20report%20generation%20in%20Access%20on%20a%20scheduled%20basis%20and%20send%20them%20externally%20for%20viewing%20on%20a%20phone%20for%20mobile%20use%20since%20access%20is%20PC%20only%20based%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2671718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2671865%22%20slang%3D%22en-US%22%3ERe%3A%20Automate%20Sending%20Reports%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2671865%22%20slang%3D%22en-US%22%3EExport%20the%20report%20as%20a%20PDF%20and%20email%20it%20so%20it%20can%20be%20viewed%20on%20a%20mobile%20phone%20as%20an%20attachment.%3CBR%20%2F%3ECreate%20a%20macro%20to%20do%20the%20whole%20process%20automatically%20i.e.%20run%20the%20report%2C%20save%20as%20PDF%20%26amp%3B%20then%20create%20the%20email%20e.g.%20using%20CDO%3CBR%20%2F%3EYou%20can%20then%20use%20Windows%20Task%20Scheduler%20to%20open%20Access%20using%20the%20%2Fmacro%20switch%20at%20specified%20times%2Fdates%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2671944%22%20slang%3D%22de-DE%22%3ESubject%3A%20Automate%20Sending%20Reports%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2671944%22%20slang%3D%22de-DE%22%3EI%20have%20developed%20several%20batch%20apps%20with%20Access%20and%20VBA%20which%2C%20among%20other%20things%2C%20are%20started%20periodically%20with%20Windows%20Task%20Scheduler.%20Exactly%20as%20isladogs%20has%20described.%20Some%20apps%20generate%20PDF%20reports%20that%20are%20created%20with%20Microsoft%20Print%20to%20PDF%20and%20sent%20as%20attachments%20via%20email%20to%20various%20employees%20in%20our%20company.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20works%20excellently.%20I%20can't%20think%20of%20a%20better%20tool%20to%20do%20this%20work%20with.%3C%2FLINGO-BODY%3E
Occasional Visitor
Is there a way to automate report generation in Access on a scheduled basis and send them externally for viewing on a phone for mobile use since access is PC only based?
2 Replies
Export the report as a PDF and email it so it can be viewed on a mobile phone as an attachment.
Create a macro to do the whole process automatically i.e. run the report, save as PDF & then create the email e.g. using CDO
You can then use Windows Task Scheduler to open Access using the /macro switch at specified times/dates
I have developed several batch apps with Access and VBA which, among other things, are started periodically with Windows Task Scheduler. Exactly as isladogs has described. Some apps generate PDF reports that are created with Microsoft Print to PDF and sent as attachments via email to various employees in our company.

This works excellently. I can't think of a better tool to do this work with.