Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2014, 02:05 PM
redzan redzan is offline macro to find a character and insert space so autocorrect will expand Windows 7 32bit macro to find a character and insert space so autocorrect will expand Office 2003
Advanced Beginner
macro to find a character and insert space so autocorrect will expand
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default macro to find a character and insert space so autocorrect will expand

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?
Reply With Quote
  #2  
Old 05-22-2014, 04:13 PM
macropod's Avatar
macropod macropod is offline macro to find a character and insert space so autocorrect will expand Windows 7 32bit macro to find a character and insert space so autocorrect will expand Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Where does the @ come from? In any event, since you have the @, why not use Find/Replace to change it to the credentials? Storing all these details as autocorrect entries is not to be recommended and, in any event, having VBA (or Find/Replace)insert a space after them won't trigger the autocorrect.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-22-2014, 04:17 PM
redzan redzan is offline macro to find a character and insert space so autocorrect will expand Windows 7 32bit macro to find a character and insert space so autocorrect will expand Office 2003
Advanced Beginner
macro to find a character and insert space so autocorrect will expand
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default

Mail merge places the @ after the name so I can easily maneuver to it with a find macro to add the space and expand.
Reply With Quote
  #4  
Old 05-22-2014, 04:22 PM
macropod's Avatar
macropod macropod is offline macro to find a character and insert space so autocorrect will expand Windows 7 32bit macro to find a character and insert space so autocorrect will expand Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless the @ is in the data source the mailmerge doesn't add it to the output. If it's a separate field, then it can be omitted from the mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to find a character and insert space so autocorrect will expand autocorrect double space to single space frankjake Word 8 09-21-2018 05:44 PM
macro to find a character and insert space so autocorrect will expand Conditional tied to trying to find a " " space character Dart82 Word VBA 3 10-04-2013 01:47 PM
macro to find a character and insert space so autocorrect will expand autocorrect: cannot find corresponding entry that produces particular behavior beej Outlook 1 11-02-2012 12:19 PM
macro to find a character and insert space so autocorrect will expand Character that looks like a space but isn't! simjambra Word 3 12-08-2011 04:36 PM
Can i insert a thumbnail image, but expand it during my presentation? deejaycruiser PowerPoint 1 11-10-2010 11:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft