Sending A Query - Daily

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

Guest

How can I schedule a daily email to users - only using the Macro
functionality? Without opening the database every day?
I understand how to use the SendObject functions, however, I do not know how
to schedule the macro?

thanks
 
You can use Windows Task Manager, or a third-party schuduling utility.
The command line will probably need to follow this syntax...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /NameOfMacro
 
Thanks Steve for the response.
However, I get this message when I try to run the syntax:
"The command line you used to start Microsoft Office Access contains an
option that Microsoft Office Access doesn't recognize. Exit and restart
Microsoft Office Access using valid command-line options."

I think it has something to do with the Macro name...when I remove it from
the syntax, it opens ok. I do have a password on the db though, could this
be the problem?

thanks -
 
<blush> I am very sorry, there was a basic mistake in the information I
gave you, there needs to be a /x switch in the command line to activate
the macro. Apologies. I am not sure about the password.
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x NameOfMacro
 
Last question...
When I use the "Send Object" Command, it only opens Outlook, which requires
me to hit "Send". Ho can I have the Query, for example, send automatically
just by running the Macro?
 
In the macro, what is the setting of the Edit Message argument of the
SendObject action? It needs to be set to No for what you want. If it
already set to No, then you may be coming up against a security feature
of Outlook.
 
If the problem is what I think it is, as far as I know, this can not be
disabled, although a post to an Outlook newsgroup
may get you a more authoritative opinion on this. I know that some
people have had success with overcoming this problem using a free
utility called ClickYes. See
http://www.express-soft.com/mailmate/clickyes.html
 
Yep! I had to install that to get Send Object to work with Outlook 2003.

And it works well.
 
I believe Gary was referring to ClickYes, as mentioned in my earlier
post, which I will now repeat...

If the problem is what I think it is, as far as I know, this can not be
disabled, although a post to an Outlook newsgroup
may get you a more authoritative opinion on this. I know that some
people have had success with overcoming this problem using a free
utility called ClickYes. See
http://www.express-soft.com/mailmate/clickyes.html
 
Steve, thanks for attempting to clarify my email. The link you provided
contains many "downloadable" products, such as NeoDownloader,
NeoDownloaderLite, Robotask, ect. As I repeat, my question to Gary was
"What exactly did you download?"....My assumption is that it was RoboTask,
however, I just want to confirm. Also, I do not see any "ClickYes" in the
link you sent...
Just an observation...
Thanks.
 
Like Steve says...

Click Yes...

Works well.

So I do not know why I had troubles using OE and Outlook just worked....
bizarre!




"Send Object Command - Two attachments"
 
The link that Steve provided was incorrect. I found another website and
downloaded Click Yes. It works like a charm now...
Thanks to all - including Steve.
OP
 
I used this method with Windows Scheduled Tasks, it opens the DB, but it does
not run the macro. I have the /x NameOfMacro at the end of the path. When the
DB opens, it just highlights the Macro. Can you help me out. I want to stop
using AutoExec.

Thanks,
Peggy
 
I am having the same issue. It used to work but it was using the MSaccess97
runtime and had the issue of incompatable database versions, we are using
2003.

Mike said:
I used this method with Windows Scheduled Tasks, it opens the DB, but it does
not run the macro. I have the /x NameOfMacro at the end of the path. When the
DB opens, it just highlights the Macro. Can you help me out. I want to stop
using AutoExec.

Thanks,
Peggy
<blush> I am very sorry, there was a basic mistake in the information I
gave you, there needs to be a /x switch in the command line to activate
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
Back
Top