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
1) Make a copy of your latest Visa file and give it a new name
2) Goto VBA and doubleclick on mudule1 and view each sub at a time.
3) Locate the sub ImportWesternUnion and delete the whole code that is there.
4) Paste the below code after any End Sub.
Open in new window
5) SAVE and Exit the workbook.
6) Open it and Try it having a mail not desired in hte inbox try having more than one.
7) When you run the Import WU/MG Emails button it create a trace in the sheet Main look for the items imported and if an item is not Imported it will tell you.
Also check the data if it was imported or not.
gowflow