Multi Workbooks / Emails

[Richard]

Hi

I currently use 3 seperate workbooks on different regular time intervals, 1
daily, 1 weekly, 1 monthly. Each executes it's own code on opening, each
generates it's own email to a unique list of recipients. I only send each
email after making some checks to ensure the data in each spreadsheet is
correct. Unfortunately when I am on leave the weekly and monthly sheets tend
to be forgotten. I need to be able to run 1 macro which allows me to perform
my check prior to sending the first email, before it moves on to the next
workbook.

Thanks in advance for the help.
Richard