Results 1 to 2 of 2
  1. #1
    tariq nawaz is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    31

    exporting a table in excel format and email as well at a certain time of day


    i want to export a table in access table .
    1. for example every day at 8.00 it create an output excel file.
    2. Attach the file and send to a fixed email at that time.

    regards

    A learner

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    One way to send is with SendObject method. Review http://www.fmsinc.com/MicrosoftAcces...endObject.html

    The time automation is another issue and not so easy.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Exporting a query to a specific Excel format
    By Ronald Mcdonald in forum Import/Export Data
    Replies: 3
    Last Post: 04-27-2012, 10:29 AM
  2. Replies: 1
    Last Post: 04-05-2012, 01:08 PM
  3. Collect Data Through Email in Table Format
    By snadeemshaikh in forum Access
    Replies: 1
    Last Post: 08-03-2011, 12:31 AM
  4. Exporting from a Access Table to Excel PivotTable
    By runthis457 in forum Import/Export Data
    Replies: 2
    Last Post: 02-12-2011, 09:06 PM
  5. Date format exporting to txt
    By timpepu in forum Access
    Replies: 1
    Last Post: 04-20-2010, 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