View Single Post
 
Old 12-18-2014, 09:15 PM
davidhuy davidhuy is offline Mac OS X Office for Mac 2011
Novice
 
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