value
3 TopicsMail: Problems Get MIME content of a message
Hello, I wrote a program in Java that monitors an inbox and retrieves new incoming emails and, after successful processing, moves them to a Processed folder. For a few emails, retrieving the MIME content of a message fails and they are moved to an error directory. If I move the emails back to the inbox by hand/in Outlook, they are processed normally. If I move them programmatically or via a Prower Automate flow, the problem remains and they cannot be processed. Ideas? Error: java.util.concurrent.ExecutionException: java.nio.charset.MalformedInputException: Input length = 1 at org.apache.hc.core5.concurrent.BasicFuture.getResult(BasicFuture.java:72) at org.apache.hc.core5.concurrent.BasicFuture.get(BasicFuture.java:85)353Views0likes0Commentsif then formula help
I am trying to use the If-Then capability to compare the first cell with one specific value to a second cell that is already a formula using dates. The second cell looks at two different dates and calculates the number of days between them. Then, if the first cell has a specific word in it (from a pull down set of choices) i want the second cell to show that number of days that were calculated and if the first cell is any other word then to show 0 (zero) in the second cell.919Views0likes1CommentConditional Formatting - Consider Only Value as Lowest Value
When "Formatting Cells Based on Value" if there is only one cell with data out of a set of otherwise blank cells, the rule considers the existent data as highest value. This makes sense logically, but I want the lowest value, even if it is the only value, to display as such. I can't figure out how to use another rule to eliminate the blank cells from the value-based rule. Thanks in advance!Solved6.6KViews0likes2Comments