I have a working bulk mail script which is supposed to be sent to thousands of users. I have started sending the mails but needed to abort because there was something wrong with the message body. How do I resume the mail from where it left off? Assuming it was sent to 200 emails, how do I send it to the rest? Thanks

Omit the first 200 addresses from the mailing list.

is this possible without deleting the data in the database?

Why do you need to delete the data? Just change your query to include a limit and offset. E.g. LIMIT 0 OFFSET 200