Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Auto Run Report then Auto Email

    Is there a way to code in Access to have a report run at 16:00 Mon - Fri, then once it has run, auto-email? From googling it looks like I would have to have access open, and I could build a form and then I could use the timer event to close the form once all tasks were complete. Does anyone else have suggestions/thoughts/ideas/?

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    You don't have to leave Access open. You can use Windows Task Scheduler to open your Access database at the specified time each day. You can specify a parm on the command line. You can have an autoexec macro run a vba function that checks for the parm passed from the command line and then opens your report, sends the e-mail and (optionally) shuts down the application.

    See this link for more info: http://support.microsoft.com/kb/207672

    See my "Application Beginnings" example Stage 1 for an example autoexec macro and function: http://peterssoftware.com/ab.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto email not working
    By edzigns in forum Programming
    Replies: 1
    Last Post: 04-29-2011, 12:41 PM
  2. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  3. Auto email query
    By warrigal in forum Database Design
    Replies: 3
    Last Post: 03-23-2011, 07:09 PM
  4. Auto Print Report for each record in table...
    By access32 in forum Reports
    Replies: 1
    Last Post: 12-17-2010, 11:46 AM
  5. Auto Unique Number on every REPORT
    By imvineet in forum Access
    Replies: 3
    Last Post: 09-09-2010, 08:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums