Sending A Query - Daily

[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

 

[Steve Schapel]

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

 

[Guest]

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 -

 

[Steve Schapel]

<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

 

[Guest]

Yep - that did the trick!!

Thanks again. I will have to look into the password prob...

 

[Guest]

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?

 

[Steve Schapel]

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.

 

[Guest]

It is set to "No" -
I will check on the Outlook side - thansk again

 

[Steve Schapel]

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

 

[Gary J. Dikkema]

Yep! I had to install that to get Send Object to work with Outlook 2003.

And it works well.

 

[Guest]

Gary...Help me out here...What exactly did you install? I'm clueless...

Thanks!

 

[Steve Schapel]

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

 

[Guest]

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.

 

[Gary J. Dikkema]

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"

 

[Guest]

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

 

[Steve Schapel]

Ok, that clarifies the confusion. The link I posted was definitely
where ClickYes was available in the past, so maybe there's been a buyout
or some such. Anyway, you didn't mention where you found it, but it
looks like it's here:
http://www.contextmagic.com/express-clickyes/

 

[Guest]

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

 

[Mike via AccessMonster.com]

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.

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

[quoted text clipped - 12 lines]