I need relevant data from sales listings for houses for sale to be lifted and inserted into Excel.
As per the attached file, I need the following details lifted from individual emails;
Sales agency name
Individual agent name
Agent's mobile number
Whether that mobile number is on the Optus network (determined via [login to view URL])
Agent's email address
Full subject property address
I need the sheet formatting to remain as it is currently.