I posted this also in mail merge but I'm now thinking maybe a macro could perform what I need.



I have a document with names in it like this:
John Smith@

I've tried to create a macro to find @ and replace with a space so autocorrect will expand to John Smith, MD.

It doesn't work because it just adds the space and autocorrect doesn't expand. Any way to make this work?