In Word it was to do automatic document conversions from WordPerfect, in Excel it was normalizing data such as fixing short UPC codes, etc. and in Outlook it was a routine to scan the body of a message looking for a specific indicator, then forward the message to a pre-determined route.