Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro Question

Status
Not open for further replies.

AGoodGuy

Programmer
Joined
Aug 16, 2011
Messages
32
I have a standard report done in Access 2007. Is it possible to create a macro in VBA to have that standard report sent to coworkers at a certain time?
 
thread707-322006
with Application.ontime should get you started.

Gavin
 

Yes it is, there are several ways to do this.

1) set the project to run as a scheduled task
2) set the email to go on a specific event
3) set a time delay so that Access simply sits and waits until the time desired occurs

The link given does cover a lot of good info.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top