User Submitted Macro

Willy's Helpers

Written by Willy Vanhaelen

What they do

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.

To install

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.

To use

  • Proper Case – Highlight some text. Press Ctrl+Alt+P to ‘Capitalize The First Letter Of Each Word’.
  • Title Widener – Press Ctrl+Alt+Shift+H and enter text into the prompt. It will be converted into a ‘W I D E T I T L E’.
  • Stripmail – Copy an email containing extra > characters to the clipboard. Press Ctrl+Alt+Shift+S to remove the > characters and have the result typed out.

How it works

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.

Requirements

– Macro Express Pro