A beginner trying to create Mailing List script.

[Zimmy]

I use FileMakerPro 5.5v1 for my mailing lists (which I send as a file to a mailing house who will ink-jet our envelopes & catalogs). I'm a beginner at all this. If someone could please help me with the following task (?script?), it would be much appreciated:

I have a primary delivery address field (ADDPRIM) and a secondary address (ADDSEC) field. How could I set up a script that would automate the following for each of the records in a given mailing list file:

In each given record of my list file, if the ADDPRIM field does not contain data, then move the data from the ADDSEC field to the ADDPRIM field. (But if both ADDPRIM & ADDSEC fields contain data, or if only ADDPRIM contains data, then leave that record as is.)

Remember that I don't understand much about FMP, so if you are kind enough to offer advice, please give your instructions step-by-step. Thanks for any help on this!

Best wishes,

-zimmy

www.zimmy.com

[slstrother]

Try the following script

Show All Records

Go to Record/Request/Page[ First ]

Loop

If [ IsEmpty(addprim) ]

Set Field [ addprim, addsec ]

Clear [ addsec ][ Select entire contents ]

End If

Go to Record/Request/Page[ Next, Exit after last ]

End Loop

Go to Record/Request/Page[ First ]

Exit Record/Request

I would suggest trying this on a copy of your database to make sure that it behaves correctly.

[andygaunt]

Or,

you could create a mailing label address that is a calculation

If (not IsEmpty(AddPrimary), AddPrimary, AddSecondary)

and repeat for each field required for the address down to

If (not IsEmpty(AddPrimary), AddZipPrimary, AddZipSecondary)

Then, you just export the mailing label fields.