Solved

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

Posted on 2006-06-24
4
338 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Printing Portal records 7 190
Help with getting the most recent date in FileMaker Pro 9 10 81
sending mail from filemaker pro 10 5 62
Access vs. Filemaker Pro vs. SQL Server 4 209
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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Suggested Courses

751 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