Sign in to follow this  
Followers 0

Sending datas in a pre-formatted Word document


6 posts in this topic

Posted

Hello everyone,

I'm developing a little FMP database on Mac to help creating reports with MS Words. These reports will contain :

- non changing elements : logo and address, first level hierarchy titles…

- some specific datas from FMP : number and name of the affair, name and adress of the client…

- the text of the report directly typed in Word by the user.

So my need is :

- when all the fields are completed, user clics on "Create report" then :

- it creates a new folder with number and name of the affair,

- creates the report file by duplicating from the report template, naming it with number & name of the affair &.doc

- inserts datas from FMP (juste one record)

- add the file into a multimedia field to less user clic on it to open it.

All this by script of course for the user only clics on one button.

So what is the best way or what is the right plug-in for it ? I'm not familiar with Applescript nor VBA so I would prefer not have to use them.

Thanks all for your answers or suggestions.

Share this post


Link to post
Share on other sites

Posted

The only plugin I know that interacts with Word is 306work's Scribe. The OS ops, creating a folder, etc., can be accomplished with their ScriptMaster product.

Share this post


Link to post
Share on other sites

Posted

I'm not familiar with Applescript

Actually, Applescript may be your best option here - other than using a dedicated plugin (plus another plugin for the OS tasks).

What makes Word so attractive as an output format - compared to PDF, for example?

Share this post


Link to post
Share on other sites

Posted

Or even RTF?

Share this post


Link to post
Share on other sites

Posted

RTF is not easily produced either - unlike PDF.

Share this post


Link to post
Share on other sites

Posted

It's definitely worth examining the requirement that the final product is a Word doc. Sometimes, that is a relic of an old workflow, similar to "we must have reports in Excel."

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0