exiting script after 100 record count

[hooty]

So I want a script that will send out batches of email to everyone in a large database. mostly I want it to go in groups of 99 to get past a home business's server limitations.

any hints? I tried things and loops and counts but I'm in over my head.

[Søren Dyhr]

You are on the right track! - try this:

Set Variable [ $theCounter; Value:0 ] 

Loop 

      Show All Records 

      Go to Record/Request/Page [ First ] 

      Omit Multiple Records [ $theCounter ] [ No dialog ] 

      Exit Loop If [  not Get ( FoundCount ) ] 

      Go to Record/Request/Page [ 101 ] [ No dialog ] 

      Omit Multiple Records [ 999999 ] [ No dialog ] 

      #<<<< put the email script or scriptstep here! 

      Set Variable [ $theCounter; Value:$theCounter+100 ] 

End Loop 

--sd

[hooty]

THANK YOU, trying this now but grateful for any reply at all:D I'll let you know if it works.

[Søren Dyhr]

Now it isn't rocket science, and my hunch tells me there might be a faster and more clever way to achieve the same result!

--sd

[hooty]

worked perfectly, thank you thank you didn't even know that variable script step existed!

I always learn so much from you guys when I stop by!