JaseSt
asked on
fixing previous solution
The attached scrubbed workbook has a macro that imports emails from Outlook into different sheets when the credit card number in the email = cell D2. It use to highlight the category of the email red or green if not processed or processed.
Since I switched over to Outlook 2010 (had Outlook 2007 before) it no longer puts a color to indicate the status. It does, however say Not Processed or Processed. I would like it to use colors instead as it is much easier to see.
I also attach a screenshot at what the Visa card is doing (correctly) and what the Mastercard workbook is doing.MC-Spreadsheet-scrubbed.xlsm
Since I switched over to Outlook 2010 (had Outlook 2007 before) it no longer puts a color to indicate the status. It does, however say Not Processed or Processed. I would like it to use colors instead as it is much easier to see.
I also attach a screenshot at what the Visa card is doing (correctly) and what the Mastercard workbook is doing.MC-Spreadsheet-scrubbed.xlsm
ASKER
it's when I activate the email into tabs option - that's when it's supposed to go through the email, extract the data and import it into the spreadsheet, then highlight the emails either red (for not processed) and green (for processed)
However, keep in mind and you may remember, that a pass with the visa function will leave mc emails red which then when picked up the mc function will turn them green.
However, keep in mind and you may remember, that a pass with the visa function will leave mc emails red which then when picked up the mc function will turn them green.
Well the function actually put them as Processed and Not Processed in MC so what do you want to do ? Shall we put the Processed to Green and the not processed to Red or .. ?
U tell me
gowflow
U tell me
gowflow
ASKER
yes, put the Processed to Green and the not processed to Red
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any chance to hv tired it out ?
gowflow
gowflow
ASKER
Works perfectly, gowflow! Thank you!
gr8. Anything else let me know in here.
gowflow
gowflow
ASKER
And if you're willing, this one:
https://www.experts-exchange.com/questions/27995435/improve-previous-solution.html
Has to do with importing data into Visa Consolidated from the Visa workbook.
https://www.experts-exchange.com/questions/27995435/improve-previous-solution.html
Has to do with importing data into Visa Consolidated from the Visa workbook.
Do not see any Sub for that was developped for that new question. If u hv it pls post it so I can see it.
gowflow
gowflow
gowflow