exporting/sending data

F

f

I created a macro, which does the following:

a)Uses the OutputTo Action to export the data to an Excel
spreadsheet. The AutoStart is on;

b)Uses the SendObject Action to send the report in Excel
format to a specified email address; The Autostart is on

My question is:
How can I automate this action? The database backend,
sits on a Windows NT Server. Each user has a front-end
on their desktop; I need the database to once a day
let's say at 12:01 am) to send this email.

Right now, it can send the email wsith the Excel
spreadsheet attachment, but it is manual.

Any help would be appreciated.

-f
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

output/sendmail 0
Convert Excel sprdsht with data in checked boxes to Access databas 1
Exporting multiple queries into Excel workbook tabs 10
Exporting Data to Multiple Tabs in Excel 1
Backend as email attachment 4
Export Data from Access to Excel 0
Export: use SendObject or Transfer? 2
Save as excel file with password 1

Top