Jump to content

  •  

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,787 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 23h 13m 26s

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,454 posts
  • Time Online: 340d 8h 41m 31s

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
  • 267 posts
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Novice
  • Membership:TechNet
  • Time Online: 5d 22h 4m 16s

Posted 13 October 2011 - 05:53 PM

Or even RTF?
  • 0

#5 comment  consultant

comment
  • Members
  • 24,454 posts
  • Time Online: 340d 8h 41m 31s

Posted 13 October 2011 - 06:19 PM

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

#6 bcooney  consultant

bcooney
  • Moderators
  • 5,787 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 23h 13m 26s

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