Help needed

I have tried to write a script to do the following:

  1. open excel spreadsheet and have it update itself via a Data Refresh ->quit
  2. open a mail merge document and use updated data source (optional)
  3. Once the mail merge is run to add generic lines of text at the top of the document and generic text at the bottom and finally remove all section breaks ^b and replace them with ^p. End result one document.

I have tried to get this to work with Automator to no avail and any help would be appreciated.


Browser: Firefox 3.0.5
Operating System: Mac OS X (10.4)