#1
|
|||
|
|||
How do I find/replace the same word in multiple documents?
I run a small business and have about two hundred customers I invoice every month. Currently, I change the date and the verbiage manually each month for each invoice. Is there a way to edit one invoice and have the change automatically apply to the rest of them? I know there is a 'find/replace' to replace all words in the same document, but is there a 'find/replace' type action I can use to edit multiple documents? Any help would be greatly appreciated! Thanks |
#2
|
||||
|
||||
See, for example:
https://www.msofficeforums.com/word-...html#post55512 https://www.msofficeforums.com/word-...html#post59393 However, it seems to me you should probably be using a mailmerge to produce your invoices, rather than manually editing anything. Of course, this pre-supposes you have a data source (eg an Access database or Excel workbook) that could be used to produce the mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
macropod...thank you, that helps a lot! Do you happen to know if I would be able to use the Mail Merge if the invoices are for different amounts?
|
#4
|
||||
|
||||
Indeed you can, that's the kind of thing they're commonly used for. A mailmerge would use, say, an Excel file with different columns (fields) for each of:
• Name • Address • Locality • State • Zip/Post Code • Past Due • Payment(s) Received • Latest Charges • Taxes • Total Some of these might require more than one column (e.g. you might have Name, Company Position, Company name, etc) or might be split (e.g. Street # & Street Name instead of the lot in one Address field) or, if you're not concerned with granularity, you might combine Locality, State & Zip/Post Code in a single column (field). The Total could be calculated from the others. For an idea of what can be achieved, see: https://www.msofficeforums.com/mail-...html#post23345 https://www.msofficeforums.com/mail-...html#post30327 Most mailmerges don't require that level of complexity, though.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
editing multiple, find/replace |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Replace text in multiple documents? | Roscoe | Word VBA | 7 | 07-31-2017 04:02 PM |
How do I find and replace multiple items at once? | redzan | Word VBA | 1 | 05-16-2013 08:25 AM |
Bad view when using Find and Find & Replace - Word places found string on top line | paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Find and Replace multiple lines/paragraphs | jcw | Word | 1 | 11-18-2011 11:47 AM |
Find and replace multiple documents change style | BaPW | Word | 0 | 08-14-2011 11:12 AM |