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 Chris 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
Aug 16, 2011
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