Update booking records and prompt guest email collection

Booking emails arrive with inconsistent guest data, leaving reservations incomplete and check-in links undelivered. Make the bookings sheet accurate and flag missing emails so coordinators can request them and finish check-in same day.