Break up recordset

[kloner]

Hi all,

I have a record set of about 300 records

I need to break it up into lots of 50 or so on the one page.
eg var 1 holding from 1 - 49
var2 50 - 99
var3 100 - 149
etc.

I have a mailto line on a <a href and I want to put a list on names form the database in the BCC line. I have found that there is a limit on the number of addresses you can have in the BCC line. so I have to break it up.

Any help would be really good cause I'm sick of swearing at the computer


kloner

 

[mudgey]

This above question is likely to be running on NT4 not Win2000