I have tried to write a script to do the following:
- open excel spreadsheet and have it update itself via a Data Refresh ->quit
- open a mail merge document and use updated data source (optional)
- 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)