March 6, 200322 yr Newbies How can I write a script to send text from a field in filemaker to MS word and automate the MS word formatting of the text?
March 6, 200322 yr At least a couple of ways come to mind. If you wish to export a complete Word document, you can export in RTF (Rich Text Format). What I usually do is save an existing version of the Word document in RTF format from within Word to get a copy of what the RTF looks like. I then cut and past the RTF into a FM calculation(s) and replace the appropriate parts of the RTF with fields. An export from FM and opening with Word gives a formatted document. The classic way to do letters is to export a merge file with data for use in a Mail Merge operation within Word. All you need to create in FM is the appropriately formatted merge file, the (say) letter template is created from within Word. Now is suppose it is possible to export XML from FM and use an XSL style sheet to perform the needed formatting, but I have not tried this. -bd
Create an account or sign in to comment