Hi guys,
It's been a while since i've needed your help but I'm really stuck on this one.
I receive customer leads via a website form into Gmail that i need to organise somehow.
When they arrive in Gmail they are automatically labelled and sent to a folder called Biowash - Enquiries as shown in attached Gmail Folder.jpg image
I would then want any new unread emails to be extracted (as highlighted in Gmail Folder Body Text + Header Info.jpg image attached), sorted and added to a spreadsheet in the format as shown in the attached Customer orders.xlsm file in sheet 2
I've copy and pasted 1 email files data into sheet 1 of the same file.
I've tried to explain this as best i can but let me know if more clarity is required.
Many thanks in advance to anyone making any attempt to provide a solution for me.
Regards
John
Bookmarks