By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

schedule report mailing without leaving access open?

P: n/a
Is there a way I can schedule something that will open an access
database, run a report, email it to an Outlook distibution list (in
word/RTF format), and then close the database? All of this is using
Access 2003.

If I use a macro then I have the be in the database already!

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Will that just open the database, or will that actually run the a
report, email it, and then close the database?

Or at least is there a way to open the database and open a form?

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a
You can use the AutoExec macro. It executes when you open the database
(unless you hold the Shift key). A simple OpenForm will do; do the rest
of your activities from that form, I'd say.

Michael Botsko wrote:
Will that just open the database, or will that actually run the a
report, email it, and then close the database?

Or at least is there a way to open the database and open a form?

*** Sent via Developersdex http://www.developersdex.com ***


--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea

Nov 13 '05 #4

P: n/a
it's a scheduler. it'll open the database. You could create a macro
to call the code you need to do the rest.

Yeah, the code will even cook your dinner.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.