I am trying to automate a data dump into Word. My client wants to be able to take some of the results, press a button and have it "magically appear" in Word so she can fine tune the information into a report.

My problem is I can't get AppleScript to allow the copy from FM to Word. I get an error message along the lines of "Word does not have access to that data." I have never used AppleScript before so I do not know the rules of data sharing in this program. Can someone point me to a resource that explains this or tell me the theory behind what I want to do?

I started with this script in FMP:

tell application "Microsoft Word"

activate

make new document at the beginning of documents

set the name of window 1 to "New Filemaker Report"

end tell

Now I want FMP to either insert the data or Word to fetch it. Now that I'm explaining my problem, is there a way to copy the data to the clipboard then paste the clipboard into Word? What would that command be?

Thanks all!

Check out http://www.chapsoft.com/ezxslt/.

A lot cleaner and very well worth the money.

I'm downloading the program but I'm not sure it's an option right now. I can't afford to buy it on my own and I'm not sure this client is going to allow an extra expendature on her bill. If I like it I'll submit it as a proposal since the data-dump is an add on to the originl program.

Either way, do you know of any other options? All I need is to send one field that is a calculation field with all the data compiled that she needs to do her report to Word.

Thanks! I'm interested to see what this program will do!

set x to cell "x" of current record

Tell application "Microsoft Word"

activate

make new document

set selection to x

end tell

or :

Write a FileMaker Script to copy the text to the clipboard

then Send AppleScript" with

Tell application "Microsoft Word"

activate

make new document

paste

end tell