Hi there, I have got 2 problems

1) I have wrote a script which pulls back the email address for all contacts that have had an appointment scheduled on that day, I wish to run this automatically which I can do, however I want to send an email automatically to the email addresses returned

2) I have wrote 4 batch jobs that run automatically and export the data to 4 seperate spreadsheets (excel), I have another excel report that collactes all the data from the other 4 and puts it all into one spreadsheet and uses formulas to be updated, however wqhen I open the file it says unable to read file and that I need to open the source to update the links

Any ideas?