How to change email recipient on form

[eluser]gazzari[/eluser]
Thanks for the replies, I ended up making a new form (non CI) and changing the links to it site wide.

The form sends to the closest distributor by postcode. All stored in a database. So back searching for the email found nothing. Back searching in general seems to go nowhere. I have never been able to backsearch in CI.

The site in general is a dogs breakfast. We have issues with newsletter unsubscribes failing, so people are getting email they don't want. There are 5 tables with email fields in them, so I have been manually searching for them and deleting. Not ideal, and it may crash something, but it seems the only way. 38 tables in total. I have a good idea what the site should do, and 38 tables is stupid.