In response to "The FinalSQL"'s question:

Yes it is possible to pump data to multiple Tabs in a excel file.

The trick? There is none. Just simply Create Table's for each new tab you require (as you did for the "Author's " tab in the example given. Be sure to specify that the connection you are using is indeed the existing Excel file! Once the table's (or Tabs) have been created, use the Transform Data Task to upload your data into the specified Tab (Indicate which tab you want to uplaod data to by selecting it in the "destination" tab of the Transaform Data Task.

Another nice feature of using teh ActiveX Scripts is that you can format your excel files after the Data Pump has been completed.

(Or you can simply utilise a template as someone has already discussed).

A lot of people seem to have problems with the ActiveX SendMail functionaility. Personnaly I have only used the XP_sendmail function or the "Send Mail Task" option in DTS Designer. This option uses a wizzard of sorts to set-up your send mail task.

Please Note that in all instances of sending mail through a DTS Package that you must have a Mail Service running in SQL Server.

I hope this helps and doesn't confuse you.