Loop through records and print

[guidojc]

Hello! I hope someone can help me, please!

I create benefit statements and I have a fm database containing over 1000 records that I need to save into individual pdf's. I am trying to write a script that will start at the first record, print/save to pdf, then go to the next record, and repeat till the last record. Currently with the script I have it just stays on the first record and never loops to the second. Any ideas on how to fix it.

This is what I have so far:

Goto layout["Statement"]

Go to Record/Request/Page[First]

Loop

Go to Record/Request/Page [Next]

Print[]

Exit Loop if ["Status (CurrentRecordNumber) = 1000"]

End Loop

Thanks Much

[DykstrL]

I think this will work for you:

Enter Browse Mode

Goto layout["Statement"]

Go to Record/Request/Page[First]

Loop

Print[]

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

End Loop

[guidojc]

Thanks! It works! But I do have one more question for you.....

When the script is running I don't actually see the records changing, is there anyway I can have fm flip through the records? Reason I am asking is I am saving each file by the persons last name, and if is doesn't flip through each record I have to get the name off another list and run the risk of making an error. Does that make sense?

Thanks again:)

[Fitch]

Try using a Refresh Window step before or after the Print step.

[guidojc]

YOU ROCK!!! Thanks so much! Have a wonderful thanksgiving