Hello,
I have an outlook inbox folder that has over 2000 responses with multiple attachments,excel file, and or pdf's, and or corporate logo jpg's. etc...
Is there any way to go into outlook and find only the excel files in the attachments and return the data from there into another excel spreadsheet?
They should all have the same Headers/Columns , but some may have 1 or more rows, and I would like to add the rows minus the header/top row into a new row on one spreadsheet
Example.
Email 1 has a PDF and excel file with 2 rows minus header data.
Email 2 has a excel file with 1 row minus header data, jpg.
Email 3 has a jpg,PDF.
Import sheet would have row 1 as headers and same columns names and VBA would fill in Rows 2 and 3 from Email 1 minus header row and fill in row 4 from Email 2 minus header row, and would skip Email 3, but keep searching inbox until all messages are searched.
Or if there's VBA code that would just extract all attachments into one folder, I have a code that can pull just the excel files from there. This one may be easier.
Either solution would work for me, Can anyone help?
Thanks in advance.
Gary
I have an outlook inbox folder that has over 2000 responses with multiple attachments,excel file, and or pdf's, and or corporate logo jpg's. etc...
Is there any way to go into outlook and find only the excel files in the attachments and return the data from there into another excel spreadsheet?
They should all have the same Headers/Columns , but some may have 1 or more rows, and I would like to add the rows minus the header/top row into a new row on one spreadsheet
Example.
Email 1 has a PDF and excel file with 2 rows minus header data.
Email 2 has a excel file with 1 row minus header data, jpg.
Email 3 has a jpg,PDF.
Import sheet would have row 1 as headers and same columns names and VBA would fill in Rows 2 and 3 from Email 1 minus header row and fill in row 4 from Email 2 minus header row, and would skip Email 3, but keep searching inbox until all messages are searched.
Or if there's VBA code that would just extract all attachments into one folder, I have a code that can pull just the excel files from there. This one may be easier.
Either solution would work for me, Can anyone help?
Thanks in advance.
Gary