I've added code to the email that writes the SQL to the page as it is sending. I see that the query is changing and the lodgeID is changing to:
LodgeIDIT = 12488 from LodgeIDIT = 1444 and that returns no email addresses.
The issue is that your form isn't passing the UpdateID in the action so that the session is being reset on the form submit because it is set from the earlier recordset filtered with that value from the url.
Update the form action to: action="" that should make it pass the same parameters in the submit that the page had originally.
Did this help? Tips are appreciated...
