Weekly monitor based on query result (1 Viewer)

Jonny

Registered User.
Local time
Today, 10:51
Joined
Aug 12, 2005
Messages
144
I wish to get notified every Sunday in 9AM o'clock with the results from the
MS Access query.
What's the best way to do that?

Thank you
 

Jonny

Registered User.
Local time
Today, 10:51
Joined
Aug 12, 2005
Messages
144
It opens Access but not sending queries..
 

mike60smart

Registered User.
Local time
Today, 08:51
Joined
Aug 6, 2017
Messages
1,899
Hi

Are the notifications reminders of some sort?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:51
Joined
Oct 29, 2018
Messages
21,357
It opens Access but not sending queries..

You don’t open Access directly. Instead, you create a script to open Access. You should create a macro to email the query and pass the name of the macro in your script.
 

Jonny

Registered User.
Local time
Today, 10:51
Joined
Aug 12, 2005
Messages
144
I wish to get every Sunday a list of employees with the upcoming birthday.
 

Jonny

Registered User.
Local time
Today, 10:51
Joined
Aug 12, 2005
Messages
144
You don’t open Access directly. Instead, you create a script to open Access. You should create a macro to email the query and pass the name of the macro in your script.

Sorry , but how I do that? Could you please clarify step by step.
 

plog

Banishment Pending
Local time
Today, 03:51
Joined
May 11, 2011
Messages
11,611
You can open Access directly in task scheduler and have this work. You just need to pass the Macro as a parameter. Here's how we did it:

1. Build VBA function to export queries to file, compose email, attache files and send.

2. Build Macro to run VBA function and then close Access. Task scheduler can run macros, but not code directly in a module, thus the need for this step.

3. Set up task scheduler to open access with that macro. Set up task scheduler like you want and then in the actual task you point it to Access and use a switch to tel it what Macro to run.

https://social.msdn.microsoft.com/F...run-a-macro-in-task-scheduler?forum=accessdev
 

Jonny

Registered User.
Local time
Today, 10:51
Joined
Aug 12, 2005
Messages
144
Solved , thanks everyone!
 
Last edited:

Users who are viewing this thread

Top Bottom