Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2014, 09:15 PM
davidhuy davidhuy is offline Macro on Search and Replace Mac OS X Macro on Search and Replace Office for Mac 2011
Novice
Macro on Search and Replace
 
Join Date: Dec 2014
Posts: 1
davidhuy is on a distinguished road
Default Macro on Search and Replace

Hi all,

I need help on doing this on Word 2011 on Mac. My current layout for my invoice is as follows:

Mr and/or Ms Client
9000 4567


user@email.com

I would like to replace the following things:
_ Mr and/or Ms Client with the actual client's name
_
9000 4567 with actual client's number
_
user@email.com with actual client's email

Client's name, number and email are from a google document form.

I'm looking for a macro that do the following things concurrently:
_ Automatically open "Find and Replace" and Find
Mr and/or Ms Client, and leave the Replace filed blank so I can fill in actual client's name.
_ After I choose replace, then another round of "Find and Replace" to find

9000 4567 and leave the Replace filed blank so I can fill in actual client's number.
_ After I choose replace, then another round of "Find and Replace" to find
user@email.com and leave the Replace filed blank so I can fill in actual client's email.

I have very limited knowledge in coding, thus hoping to seek help from you all

Thank you so much
Reply With Quote
  #2  
Old 12-19-2014, 04:47 AM
macropod's Avatar
macropod macropod is offline Macro on Search and Replace Windows 7 64bit Macro on Search and Replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You need to provide a lot more information about the source, including how the file is to be located & opened, plus how the macro would recognise each of the elements you're interested in.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro on Search and Replace Macro to search warning text style and replace the text color rohanrohith Word VBA 3 11-27-2014 01:08 PM
Macro on Search and Replace search and replace dirkoo Word VBA 2 08-14-2013 11:25 AM
Macro on Search and Replace Odd search and replace query Rabski Word 1 11-13-2012 02:25 PM
Search Replace Copy dblack7211 Word 0 05-05-2010 01:19 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 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