Can anyone help? Filemaker - Word Via Applescript!

[Mark Bowen]

Hi there,

Not sure if anyone can help with this one. It's a bit difficult.

Where I work we have a database that I designed. We are a Commercial Production Company that produces radio adverts all day long. We are currently employed in the second largest contract in Europe.

The problem is this. As we create radio ads we type in hundreds of scripts a day and they have to be in a special format, that being the voice directions go in a column on the left hand side of the page and then the script for each voice on the right.

This would be easy to do in Filemaker in just one field by using the Alt Tab (Macintosh) key to produce the desired result. However our major problem is that we have to export these scripts to Word to be able to send them to Clients and Sales Executives to peruse.

This is where I came up with a script to copy the main body of the script (the parts on the right hand side) and open up a Word template file which then has a UserForm that I created which allows you to type in information which is then auto pasted into the correct bookmark places. Once this has all been entered the copied text from Filemaker is pasted onto the page.

Unfortunately as the Mac and any computer only has one clipboard this means that the writer either has to then go back to Filemaker and manually copy the left column or type it all back in again.

If anyone is following any of this then what my question is is:

Is it possible to copy or export in some way both parts and possibly other information, open up the Word template and then insert this information into the file.

I know you could do this with a Filemaker eported file and then use the Data Import feature of Word but unfortunately the people operating the database are not really all that familiar with these procedures and also because so many scripts are created in one day then this is also not really all that practical.

If anyone can come up with a solution to this one then I would be very greatful.

The only thing I could think of was maybe copying the left side into a field and then using a seperator " | " maybe the pipe symbol and then copying the right side afterwards then when it gets to Word the information is somehow taken out.

I can do this kind of text calculation in Filemaker using the Position and Left functions etc... but does anyone know if these exist in VBScript in word on the Mac and if they do what they are called.

I will stop now and say a massive sorry for babbling on so much and also a massive big thankyou in advance to anyone who can come up with the answer to this problem.

Regards,

Mark Bowen

[email protected]

http://www.kingfishergraphics.com/phpBB/