VBA to automate and email a sales report

[moyay4]

I know there are several threads related to this, but I have not found any to solve my problem. I am new to VBA.

I have the task of pulling results of an Access query into Excel, formatting them in a "standard" way (the data will be formatted the same everytime in every report), then AUTOMATICALLY emailing them at a pre-determined time everyday.

1. I have tried using the record macro function, and it works as far as pulling in query results and formatting them
2. Then, using the macro i recorded, i added onto it so that when I manually run this new macro, the whole thing gets emailed, but it is not automated. My issue is not having to manually run these macros and have them run as scheduled tasks.

Thank you so much for any help.

 

[Smitty]

Welcome to the Board!

If you're taking advantage of the Open event, you can use the Windows Task Scheduler to open the workbook in question.

See: About the Task Scheduler (Windows)

HTH,

 

[AlphaFrog]

Use the OnTime Method to schedule a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed).

Here's a good step-by step guide
Scheduling Events With OnTime

Or do a web search for something like Excel ontime method site:www.mrexcel.com for many examples.