Word document batch amendments
Author
Discussion

R8Steve

Original Poster:

4,150 posts

206 months

Wednesday 20th February 2019
quotequote all
I need to change the mailing address in approx. 800 letters. They are all .doc Microsoft word documents stored in a main folder that then has subfolders for the different letter types.
The text I would like to change is in this format –
Company
Company address
PO Box 12345
Country
Postcode

t: telephone number
w: e-mail address

It will need changed to new address/contact details in the same format.
I can’t download add-ins so would probably need to be some kind of macro/VBA code but being honest I have no idea where to start with this.

Can anyone help me from opening, copying, pasting, closing and saving 800+ word documents? bangheadhehe

geeks

11,881 posts

170 months

Wednesday 20th February 2019
quotequote all
Mail Merge no good?

R8Steve

Original Poster:

4,150 posts

206 months

Wednesday 20th February 2019
quotequote all
geeks said:
Mail Merge no good?
Sorry, should have explained, these are all individual mail merge templates that need amended.


geeks

11,881 posts

170 months

Wednesday 20th February 2019
quotequote all
R8Steve said:
geeks said:
Mail Merge no good?
Sorry, should have explained, these are all individual mail merge templates that need amended.
Ah, in that case you're on your own hehe

Sorry not much help here.

Mr Pointy

13,435 posts

190 months

Wednesday 20th February 2019
quotequote all
Well Google came up with this:

https://wordmvp.com/FAQs/MacrosVBA/BatchFR.htm

You'd need the second procedure & make lots of backup copies first. You would probably need to run it once for every line changed

Or look at this:
http://www.office-words.com/index.html

FunkyGibbon

3,863 posts

295 months

Wednesday 20th February 2019
quotequote all

R8Steve

Original Poster:

4,150 posts

206 months

Wednesday 20th February 2019
quotequote all
Mr Pointy said:
Well Google came up with this:

https://wordmvp.com/FAQs/MacrosVBA/BatchFR.htm

You'd need the second procedure & make lots of backup copies first. You would probably need to run it once for every line changed

Or look at this:
http://www.office-words.com/index.html
Thanks for that, i'd came across the first link there when i was searching earlier and i'll maybe sound a bit daft here but what is it i do with that information? Do you copy it into a new macro and just run it? I'm not very familiar at all with macros/VBA.

I do believe that would work though.

mattley

3,039 posts

253 months

Wednesday 20th February 2019
quotequote all
Notepad++ can do a find/Replace across multiple Files in a folder

I've had limited success using it for word Docs but it's free and there's no learning curve.