My boss has asked me to do something and I’m hoping there’s an easy way to do it,
I work in a very basic guesthouse, and we receive online bookings from an online travel agent.
He’s asked me to go through these emails and write some information into an excel spreadsheet
Guest name, email address, room type, dates, country, etc.
There are over 800 of these emails, and they’re all automatically generated by the OTA, so all have the same layout/format
Is there anyway to do this that doesn’t involve me going through every email getting the info. manually?
I can get some of the info really easily off the OTA’s website, but unfortunately not email address or room type
Help me STW, you’re my only hope
p.s its from gmail account if that makes a difference?