You should be able to export a Merge file from FileMaker and then use Word's merge wizard to hook everything up. It's not fully automatic but it isn't difficult
Alternatively, you could create a Letters table in your database and then do the merge directly in FileMaker. A little bit of work to set it up properly but if the lettter template doesn't change then that might work for you.
Thank you for your answer, David.
I would prefer to do all the job inside FileMaker. My customer is not very good using computers, so it´s should be something very easy to use.
>> you could create a Letters table in your database and then do the merge directly in FileMaker.
It´s a very complex Word document: tables, images... I don´t know if it makes sense to prepare everything with a script.
I think even if your customer isn't very good with computer, the merge solution still seems the easiest way to go IF the word document is too complex to be created as a layout in filemaker. The only thing you need to do to make sure it will actually work is to do the merge yourself the first time, and then make sure that:
1) The word document stays at the same place on the users computer.
2) The data is always exported at the same place and the excel document should have exactly the same name.
I know it's not ideal, but this should work if you give the users some basic instructions ( export first from FM, then open the word document, don't move the word document, don't move the excel document, don't rename the excel document...).
Look at the Scribe plugin from 360Works. It is cross-platform and will do what you want. It also works with more than just MS Word. It works with PDF forms, Excel files, etc. You can keep everything self-contained within FileMaker with this solution.
Doug de Stwolinska
Thanks for that link. Javier needs this solution to work on the Mac though. The article author says that his techniques could be adapted using AppleScript on the Mac. I have used Scribe for Word merge in a cross-platform environment and can attest that it is pretty simple and has worked well for me. I also like that it is kind of a one stop solution in that it can be used with Excel and PDF forms.
My bad, must've overlooked the Mac requirement in his post.
360Works plugin seems to be the best solution.
Thank you for all your answers.
Did you end up using the Scribe plug-in from 360Works? Just curious to know if it solved your issue. I am dealing with a similar issue now and thinking of getting this plug in.
Yes, it worked for me.
You can download the demo version and try it for free: "While in demo mode, product will run for 2 hours every time you launch FileMaker / Server / Web Publishing. 2 hour limits are reset with every launch, with no expiration date. Demos are fully functional during time period."