Hi everyone, I get an email every week that has with a table in it that has numbers. I usually open the email, and just enter the data manually in my excel template that I use. I was wondering if there was a way or a macro which can pull this email, and copy the data into my spreadsheet?
the email comes every tuesday, by the same person with the same subject.
the contents of the email have a table and his signature usually.
is there a way to have the macro check if the email came today, and if so, pull the table into a different spreadsheet? If i can get this part down, the rest I can do as well
Thanks in advance!
the email comes every tuesday, by the same person with the same subject.
the contents of the email have a table and his signature usually.
is there a way to have the macro check if the email came today, and if so, pull the table into a different spreadsheet? If i can get this part down, the rest I can do as well
Thanks in advance!