Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Sending datas in a pre-formatted Word document

ms word word export word template

  • Please log in to reply
5 replies to this topic

#1 Charled  newbie

Charled
  • Newbies
  • PipPipPip
  • 3 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Intermediate

Posted 13 October 2011 - 07:12 AM

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.
  • 0

#2 bcooney  consultant

bcooney
  • Moderators
  • 5,746 posts
  • LocationLong Island, NY
  • FM Application:13 Advance
  • FMGo:iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10, 11, 12
  • Membership:TechNet
  • Time Online: 23d 6h 16m 3s

Posted 13 October 2011 - 12:05 PM

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.
  • 0

#3 comment  consultant

comment
  • Members
  • 24,193 posts
  • Time Online: 329d 10h 52m 7s

Posted 13 October 2011 - 01:35 PM

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?
  • 0

#4 Charity  journeyman

Charity
  • Members
  • 236 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Novice
  • Time Online: 5d 17h 51m 34s

Posted 13 October 2011 - 05:53 PM

Or even RTF?
  • 0

#5 comment  consultant

comment
  • Members
  • 24,193 posts
  • Time Online: 329d 10h 52m 7s

Posted 13 October 2011 - 06:19 PM

RTF is not easily produced either - unlike PDF.
  • 0

#6 bcooney  consultant

bcooney
  • Moderators
  • 5,746 posts
  • LocationLong Island, NY
  • FM Application:13 Advance
  • FMGo:iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10, 11, 12
  • Membership:TechNet
  • Time Online: 23d 6h 16m 3s

Posted 14 October 2011 - 06:47 AM

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."
  • 0





FMForum Advertisers