I have a series of layouts that are letters and a main page that people can enter the contact information and request a specific letter.

I could like to create a script to go to each letter layout find all that have the REQUEST DATE equal to the current date and print the records found. If no records are found then move to the next letter.

Any suggestions on how to do this?

Thanks

Note: Your question isn't completely clear, mainly because your data structure isn't clear.

I think what you're saying is that you have a Letters table and a contacts table, and that a person enters their contact info into the contacts table, and selects a letter that will subsequently get sent out to them.

If that's the case, you don't need to go to multiple layouts, and you don't need to do multiple finds.

Assuming that the Letters table is related to the people table based on the LetterID, you need to:

1) Create a Letter layout based on your Contacts table that includes appropriate Contact info--AND fields for your Letter info.

2) Create a simple script:

# PrintLetters

Set Error Capture[On]

Go To Layout[Letter1]

Enter Find Mode[]

Set Field[ReqDate; Get(CurrentDate)]

Perform Find[]

If[Get(LastError) = 0]

# Execute the print steps

End If

This will result in the selected letter being printed out for all people with today's date in the ReqDate field.

If this is not right, give us more to work with.

David