FileMaker Pro 5 Export Problem

[icarus004]

You'll have to excuse of ignorance in FileMaker Pro. I have a Filemaker 5 DB with over 2,000 records running on MAC OS 9.1. Each record has fields that detail company information, name, address, etc. I need to export these records into a Word or Excel File so that they come out like the following example...

Acme Lawn Mowers

222 James Street

Anytown, NJ 90210

When I export the records (doesn't matter what type I choose) I select the particular fields that I want to export and then click the export button. The only problem is that when I convert the document to Word, Excel, HTML, or whatever the fields are listed across the page like so...

Acme Lawn Mowers 222 James Street Anytown NJ 90210

I need to mave the fields on seperate lines like shown in the first example in order to create mailing labels. Any suggestions. Thanks in advance.

Icarus

[LiveOak]

The absolutely easiest way to do this is not to export the data, but to print the labels from FileMaker. Go to layout mode, select new layout, and follow the steps to create a layout for printing the type of Avery labels you wish. FM's selection of preformatted Avery label layouts is extensive.

The export approach will require that you do define you label layout in those programs. In Word, you can export a merge file type from FM and use mailmerge in Word. Printing directly from FM is much easier, once you get past a little bit of how to.

-bd

[icarus004]

Definitely great help! This is exactly what I wanted it to look like. Thanks.

Icarus