Send a monthly email that has the same file attached, the attached file is updated daily.

There is a way to do this, but we will need more information.

The Widows Task Scheduler has the capability to open an Excel Spreadsheet, but it cannot run a macro in that spreadsheet. However, an Excel Spreadsheet (Let's call this spreadsheet the script) can open another spreadsheet and run a macro in it (Let's call this spreadsheet the target).

The target is a normal report. In your case it will contain code (a macro) to mail the spreadsheet to the distribution list as an attachment.

I invented a script program that takes the path name to the target, the file name of the target and the macro inside the target that is to be executed. The script program also produces the command string to be used by the Windows Task Scheduler to call itself.

I keep all my scripts in one directory and all my targets in subdirectories of a separate target directory. It's just easier to manage that way.

The steps are simple, you make a copy of the script template and rename it. I suggest naming it to match the name of the target program. Fill in the blanks and copy the command string into notepad or some other text editor.

Then open the Windows Task Manager and set up the task. Copy/paste the command string into the actions section.

When the first of the month happens the Widows Task Manager opens the script spreadsheet which has an On Open trigger to call the target spreadsheet and run the macro in it.

I've attached half of the solution in _Control Template.zip. This file contains the Task Manager pieces. The other half of the solution is contained in ModMailerMain.zip. When unzipped this is a *.BAS file that contains a mail module. You'll have to write some simple code to feed it things like who to mail to, what the subject is, the body of the message and what the attachments should be.