Run Query every day and send results by email automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Windows XP Home Edition. I use MS Access 2003.
I want to automate a macro to run every evening and send send that HTML file
via email to a number of people, is that possible.
and if so How.
I need any commands relativly straight forward, although I am no numpty!!!

I would be most grateful if anyone can help

If it is not possible is there any way I can get round it or what do I need
to be able to do it?
 
Sean,

First create your macro using the SendObject action. I assume you are
talking about exporting a report or query or some such. This is likely
to be fairly straightforward.

Then set up a scheduled task in Windows, or some other third party
scheduling utility, to run at the required time. The syntax of the
Command Line for the scheduler will be something like this...
"C:\Program Files\...\Msaccess.exe" "C:\PathToDb\MyDB.mdb" /x NameOfMacro
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Access - automatically add email extensions 0
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
how do I repeat an action every day 5
Open specific hyperlink (accept) automatically in email with outlook 0
Sending email in Access that can't be replied too? 4
result of many queries send by email 2
Collecting data through email using VBA 2

Back
Top