Okay, this is it. I've got data in a FMP 9 file that I want to get into a Word 2008 file. I've managed to create a .mer file and import that into Word '08, but can't get more than one record at a time to appear.

The Word file is a booklet with linked text boxes. The idea is to fill these text boxes with the appropriate data, but, alas, no fill. I can preview the merged data, but only one file at a time appears in the text box. Does anyone know how to get the data to all appear in the same text box as opposed to each record appearing in a new doc, a in a mail merge?

I realize that this may be more of a Word 2008 question, and apologize if I've wasted your time, but I'm running out of resources. Any insight would be appreciated.

It's a Word question. All of us are wondering, "why not just do this in FM?"

That's what merge is supposed to do - it creates a document for each record. If this is a one-time effort, I suppose you could just paste your data into Word, and format it as you like. It could be automated, too - but not quite easily.

I guess the only reason I'm trying to do this through Word is that I have more experience with it. I love fmp and would prefer to do it from there, but it's all fairly new and the learning curve is steep. Are there any affordable (ie. free) solutions out there or is this something I'm going to have to wade into?

"The learning curve is steep" - take that FMI Marketing Dept!

Depends on what you want to do. FM comes with some templates that might get you started.

Here are a couple of the sponsored sites, that you will want to save as favoraites in your browser, they have many good demos, or how to files. Check this file at nightwing Merge Letter Templating System

Also, do a search for Custom Letters here Link

HTH

Lee

Thanks Lee,

I'll do some more digging. It would make sense if I can handle the whole project from within FM. What I'm actually trying to do is create a members directory that can be updated once a year without too much effort.

Brad

It's because Word is defaulting to one record per page as if you were sending letters.

(Like Form View in FM).

You need to tell Word that you want to use Mailing Labels. That way, you get you will get more that one address per page.

You will have to specify a label size that suits you (just one column). Otherwise you will get records side by side, in columns, like pages of labels usually are.

When you have just one column, and just one label in that column, you will have something like List View in FM.