I have been trying to think and do about making filemaker to Word. But it seems to me that I can not find a way to solve it. What I plan to do is to make a script to export some data to Word or all data to Word when usert click a button like in C++, can it be done in filemaker? I really need help for this topic. Someone has an idea about it?

Thanks

Anh Tran

use the load data access via ODBC from word, I have used this to make email and mail merges.

You will need knowedge of VBA in word to help the automation further though.

FMP can open the word doc and then the word doc's macro can automatically bring in the data via ODBC.

Hello Charles Delfs

Thanks alot

Do you have an example how to do it?

Anh Tran

If yu are using Word 2000 or later and Windows, you can 'fool' Word into thinking that a file is a Word document. This may even work for earlier versions of Word, but I haven't tested it.

Here's how I do it:

You convert your data into a web page, HTML file. Using a looping script, parse all of the necessary data into a single, global field, changing the data into HTML code snippets as you add the data to the global field.

Create a found set of 1 record, then export that single global field in the single record to a TAB delimited text file.

Now, here's the trick: change the file extension to ".DOC"

When you open the file in Word, ta-da ... a formatted Word document. Now, if you look at the actual coding of the document, you will see that it is actually an HTML document that Word is displaying.

Using HTML code, you can even provide text formatting to make it look just like what you want. You can even embed live links into the text.

It's not pretty code, but it does work.

Hmm Just read the first post again,

Do you want to create seperate word documents (printouts) for each record or a single document from multiple records?

Charles

As for an example I don't have but if you read the help in Filemaker and word it explains how to set up the odbc link