![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rohanrohith | Word VBA | 3 | 11-27-2014 01:08 PM |
![]() |
dirkoo | Word VBA | 2 | 08-14-2013 11:25 AM |
![]() |
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 |