Is there a way to Automate or Script the Mail Merge Feature in iWorks?
Hello,
I've been trying to build a production management system slowly over the last few months, my boss is a bit of a technophobe so I've been trying as hard as i can to keep everything in familiar programs, at its core all the system has to do its take information in from Purchase Orders, this is added to a Numbers File, within that numbers file are our Open Order Book showing All orders and 2 "Merge Sheets" all new Orders are Added to the Merge Sheets then onto the Open Order Sheet, those "merge sheets" are then used as a data source for a Pages file "Job Card" (we have 2 job card files once blue one yellow but the process is the same)
Up until now I've been manually merging each time we get a new order, but this happens a lot so what I've been trying to do is Automate the procedure.
Ive created 2 Automator Apps each runs the same sequence just for the two different Job cards as follows:
Get finder Item "Job_Card_Blue/Yellow" > Open Finder Item > a "watch me do" of mail merge > Print > Close Application without saving
The Problem is the Watch me do is a bit of a clunky work around, if I could make it work without the mouse moving over the screen it wouldn't be so bad, even if I could somehow give Mail Merge a Keyboard Short Cut it would also be better.
So my questions, after a large ammount of waffling:
1) is there a way i can "see" and then edit the "watch me do" Script?
2) is there a simpler work around im not seeing?
3) is there an existing script of program I can use? (obviously i know there is Filemaker etc, if it was up to me I'd use a Database, but the owner of company is adimant i use office or easy programs, becuase it needs to be a system i can leave to him once my contract is up)
Any Help or suggestions would be greatly appreciated!
iMac, OS X Mountain Lion (10.8.2)