Written by Willy Vanhaelen
Willy says “These 3 macros were originally created in Macro Express 3 but since I recently upgraded to Pro, I took advantage of the newly introduced External VB Script command to make an even more performant Pro version. The Proper Case and Stripmail macros are fine examples of how to pass a text variable from Macro Express to VB script.”
Proper Case – Convert highlighted text to Title Case with each word capitalized.
Title Widener – Make a title more prominent by inserting a space between each letter and making it upper case.
Stripmail – Strip > characters from email messages.
Download the macro file umwillyshelpers.mex and save it to your hard drive. Open the macro file or import the macro into your existing macro file by clicking File, Import, Import Macros.
Each of these macros uses the External Script command to run VB Script to perform the desired function. The ‘StripMail VB’ and ‘Proper Case VB’ macros use an interesting technique to pass the desired string to the script. The value to be changed is written to an environment variable and the environment variable is read by the VB Script for processing.
– Macro Express Pro
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |