rcbricker
01-26-2007, 07:10 AM
OK I have a new one. Seems the more help I give on spreadsheets the more I find that needs doing. I try and use the limited strings that I know to do the problems but always come here for faster and cleaner solutions.
This problem, I have no idea how to do.
We just received 6000 emails (Outlook) and they look like the .DOC that is attached, but the data is typed into the body of the email not attached as a word doc.
I need to have a solution that will extract the invoice number (that I highligthed on the word doc, but is not highlighted in the email) in the email and find it on a given spreadsheet. I then need to have the email flagged or moved to show that it is on the spreadsheet.
All the emails will start in the same folder but I need to be able to differentiate from the emails that contain invoice that are on the spreadsheet from those that are not on the spreadsheet.
A new development has the need for the "memo Number" data. SO he is asking if there is a way to extract the invoice number and the memo number to a spreadsheet and then have a search to verify that the invoice number is found on a second spreadsheet.
So column one will be Memo number
Column two will be invoice number and
Column three will be something to indicate that the invoice number is on the second spreadsheet, like an "X".
Any questions?
This problem, I have no idea how to do.
We just received 6000 emails (Outlook) and they look like the .DOC that is attached, but the data is typed into the body of the email not attached as a word doc.
I need to have a solution that will extract the invoice number (that I highligthed on the word doc, but is not highlighted in the email) in the email and find it on a given spreadsheet. I then need to have the email flagged or moved to show that it is on the spreadsheet.
All the emails will start in the same folder but I need to be able to differentiate from the emails that contain invoice that are on the spreadsheet from those that are not on the spreadsheet.
A new development has the need for the "memo Number" data. SO he is asking if there is a way to extract the invoice number and the memo number to a spreadsheet and then have a search to verify that the invoice number is found on a second spreadsheet.
So column one will be Memo number
Column two will be invoice number and
Column three will be something to indicate that the invoice number is on the second spreadsheet, like an "X".
Any questions?