Finding a RANGE of Records in a Script

[RPM765]

I have a large database of almost 50,000 names which i am about to use for a direct mail campaign. I want to be able to choose a range of zip codes and then export a certain number of records from that found set.

I can FIND A RANGE manually by using the range (...) symbol in the ZIP field, but how do I automate that in a script?

I have used two GLOBAL fields to store the choices for STARTING and ENDING zip codes, however I can't use them in a FIND step in a script...they are grayed out.

What am I doing wrong?

[stanley]

You can use globals in a Find by using Set Field[], thus:

Enter Find Mode[]

Set Field[YourField;StartGlobal & "..." & EndGlobal]

PerformFind[]

Remember to remove the pauses that automatically get put in.

-Stanley

[RPM765]

That worked like a charm! And FAST!

I just learned something new and valuable for the future.

Thanks very much, Stanley!