Executing Script on Found Set

[DrNikon224]

I am wanting to execute a script that sends an email message to email addresses in a found set of records. I can set up a loop to go to the first record, send email, next record, send email, (loop), but i can't seem to figure out how to get the loop to stop (Exit Loop if).

Is there an easier way to execute the same script (sendmail) on a found set of records?

thanks,

[andygaunt]

Hi,

Check the exit after last option for the Go To Next Record/Request/Page line of your script.

[DrNikon224]

...i guess i overlooked that....

thanks for the assist!.

I'm a dummy.

[Vaughan]

Alternatively (jus because you can) you could use the exit Loop step...

Exit Loop If [status(CurrentrecordNumber) = Status(CurrentFoundCount)]

I mention this only because it's a way of exiting a loop at the last record if you're not using the "Go to Record" script steps.

It's also a good intorduction to the useage of the Status functions if you haven't seen them yet. They are extremely powerful!

[LaRetta]

Vaughan,

Thanks for another powerful tid-bit! This is very clean!

LaRetta