Results 1 to 2 of 2
  1. #1
    dlburkins is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    15

    How do I create an automated script to email a db daily

    I have a list of people that I would like to send the data to daily during the week.

    This is what I would like to accomplish:
    - Send the db file daily at 6am
    - Track the recipients of the file



    Can anyone tell me where I should start with this.

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I guess I would start with SendObject; more info in VBA help. You could use the timer event of an open form to trigger it, but personally I would probably create an mdb that performed the required process and then quit, then call that mdb from Windows Scheduled Tasks.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 02-04-2010, 10:45 AM
  2. how to update data daily
    By periphery in forum Queries
    Replies: 1
    Last Post: 01-28-2010, 08:45 PM
  3. Daily Sign In form
    By JHansford in forum Access
    Replies: 2
    Last Post: 12-09-2009, 08:41 AM
  4. Creating a Daily Running Total Query
    By seraph in forum Queries
    Replies: 0
    Last Post: 08-15-2009, 12:11 AM
  5. Automated many Rpts from one??
    By techexpressinc in forum Reports
    Replies: 0
    Last Post: 07-21-2009, 08:20 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