Need to group 2 million records - Help?!

[uglydork]

I have 2.5 million email addresses in a table. I dont want to mail merge all 2.5 million and send at once. I only want to blast 1,000 at a time.
What is the best way to chunk this into smaller lists of 1,000 emails?

 

[plog]

Assign an autonumber field to the table then create a query to work through them 1000 at a time using that number.

 

[uglydork]

Thank you for your reply. I cant autonumber that high. I edited the registry to allow but it still isnt working

Assign an autonumber field to the table then create a query to work through them 1000 at a time using that number.

 

[plog]

A quick hack around this is to copy your table, paste just its structure, add the autonumber field to that new table then make an append query to put all the records from the old table to the new table.

Depending on your current database size, you may want to create this new table in an new, empty database.