Solved

FileMaker Pro 7 - Exporting a Header Record + data records for use in Mail Merge

Posted on 2006-06-24
4
340 Views
Last Modified: 2008-02-01
Is there a way in which a header record can be exported, so that the exported date file can be used as a source data file for an MS Word mailmerge template.

The header record being the names of all the fields being exported so that MS Word can match actual fields with mergeformat names.

I have tried creating a DUMMY record and pre-filled the fields with the names that I want to appear as header record field names. However, you can't always enter a text name into all fields and if you could, not that easy to always make it the first record.

I have looked everywhere within FileMaker Pro 7 and can find no parameter that can be used to export this critical detail. Ironically, FileMaker on Import allows you to align the first record of data imported. Surely there must be a reverse feature?
0
Comment
Question by:cheeseright
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 16974871
true, there is no way to export field names as the 1st data row. but you can do that easily yourself.
before exporting, create a new record, and for each field, set field value = current field name.
to do this, create a layout with all fields in it, then loop through all fields using goto next field (avoid to specify all fields, this way you can use a loop).
then you probably need an extra field to sort the way you need; for instance, sort all records the way you need, replace the sort field with a serial number, then number the header record field as 0; re-sort, then export.
I can write a little example if you like, just let me know.
you could also avoid all that stuff, create the header file on disk, export the data file the way you do it now, then concatenate both files on disk into a single file usable by word. this is only one shell command which can called by filemaker, either on mac or windows.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16974919
0
 

Author Comment

by:cheeseright
ID: 16976398
Many thanks, the first part will do very nicely and an additional thanks for the script example - worth its weight in gold.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16976642
well, great then!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question