Hello,
I'm building a message log system for my macro.
I have five message tools sequentially chained together. Each message detects a specific error. I have one that detects null entries for fields, length violations, and so forth.
The detection criteria works great.
However, I cannot get the display mechanics to work as I desire. For example: If I have 100 records that have null entries, It will output this 100 times in the message logs.
I can account for this by checking Transient, however this will overwrite the other Message Tools. In other words, if I have 100 null entries and 50 length violations, length violation message will overwrite the null entry message.
I would like to make it such that if I had 100 null entries and 50 length violations, only 2 messages are output to the message log: One for each Message Tool. How may I achieve this?
Solved! Go to Solution.
Thanks, I haven't thought of that!
I'll edit my macro to display it in this fashion.