Create an automated macro in Access which runs a query once a week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Looking to create an automated process in Access which runs a query and
exports it to Excel
 
See VBA Editor Help on TransferSpreadsheet. You can identify a select query
in place of a table as the source of the transfer.
 
Does your organization use Outlook? In Outlook, it is possible to
program code that fires on the REMINDER event for an AppointmentItem or
TaskItem. Also, because of the integration between the Office family of
products, there's pretty much nothing that can't be programed using
Outlook VBA.
 
Back
Top