Auto Mail of query results

[Guest]

Hello
Is the following available in access.
1-At a certain time each day, a query will run.
2-The results of this query is emailed auto.

If it is available , how to do it.

Thank you and best regards

 

[Guest]

About running the query in a certain time, use the windows schedular to run
an mdb, that will run the query, and then send the query resault using the
SendObject, you can Email the query as Excel file, or ..., check help on the
subject.


docmd.SendObject acSendQuery
,"QueryName",acFormatXLS,SendToAddress,,,Subject,Text

 

[Guest]

Thank you for your answer.
I used the windows schedular, but it will open the database only. How to
make the query run auto when the database is opened.

Thank you

 

[Guest]

Create a macro called Autoexec, and put the command to run the query into it.
When you will open the mdb it will automaticaly start the macro, so if you
want to open the mdb for design view hold the shift key down while opening
the mdb.

 

[Guest]

Hello
I have a problem in using command line to open the database. It will ask for
logon name and password.
I tried C:\Database\Chem\EasyTrack.mdb /user bassel/pwd 1234
but the logon screen appeared.

Can you help me solve this problem

 

[Guest]

I'm not familliar with login, mybe you can strart a new post for this question.

 

[Guest]

Thank you
--
Bassel

Hello
I have a problem in using command line to open the database. It will ask for
logon name and password.
I tried C:\Database\Chem\EasyTrack.mdb /user bassel/pwd 1234
but the logon screen appeared.

Can you help me solve this problem

 

[giuseppe d'angelo]

Thank you