slight tweak to previous solution
In a previous solution gowflow created a function that scans the inbox of my Outlook 2010 and imports data that meets a certain criteria into the WU-Staging-FBME sheet of my Visa workbook. It works great.
However, there is one problem: It also tries to import emails that have the criteria in the HISTORY of the email.
Attached is a scrubbed example of the type of email that should (and does) import. (JEN-ExampleofCardNumber)JEN-ExampleofCardNumberThatDoesI.msg
There is also attached an example of a scrubbed email that has the Western Union data, but it is in the history of a email and should not be sent. (Re-Shawn-112112-1)
RE-Shawn-112112-1-----2235.msg
However, there is one problem: It also tries to import emails that have the criteria in the HISTORY of the email.
Attached is a scrubbed example of the type of email that should (and does) import. (JEN-ExampleofCardNumber)JEN-ExampleofCardNumberThatDoesI.msg
There is also attached an example of a scrubbed email that has the Western Union data, but it is in the history of a email and should not be sent. (Re-Shawn-112112-1)
RE-Shawn-112112-1-----2235.msg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay but had to wait for a real email that met the criteria to test against.
Tried to import the attached but nothing copied to the spreadsheet.
It does, however, import the original WU pickup request emails just fine.RE-Pickup-request-transfer-Weste.msg
Tried to import the attached but nothing copied to the spreadsheet.
It does, however, import the original WU pickup request emails just fine.RE-Pickup-request-transfer-Weste.msg
Well it is not that that you want ???? This mail is not original and it is a replied to an other Email !!!! then it is not imported. That is not what you have asked ???
gowflow
gowflow
ASKER
I see. You are basing the function on a reply email?
However, there are times when they put a current and valid pick up request at the top of a replied to email which contains previous pickup requests already imported to the spreadsheet as in the posted example. But those are rare. For now let's just keep it as is.
I will accept this solution and if I find I need further tweaking I will let you know.
However, there are times when they put a current and valid pick up request at the top of a replied to email which contains previous pickup requests already imported to the spreadsheet as in the posted example. But those are rare. For now let's just keep it as is.
I will accept this solution and if I find I need further tweaking I will let you know.
ASKER
Works as requested. Great work. Thank you gowflow!
Another one coming up - more involved - if willing.
Another one coming up - more involved - if willing.
ASKER
ASKER
gowflow, this function choked with on the attached email. Can it be modified to work with emails of this sort?Re-SGC-Mastercard-Application--a.msg
gowflow