Greg,
Thanks for the latest update!
Of course now that i have this working, management has decided that the line here:
doesnt need an array check. there is now just Change Classification property to check. could you modify so this is the case? Thanks in advance' Define the names of the custom properties to check arrProperties = Split("DCR Type|Change Classification", "|")