bulk replacing email addresses in Word docs.
in [Microsoft Office]
|
Prev: Preventing mails from being copied or forwarded.
Next: como passar do office 2000 para o office 2003?
From: Maurice on 8 May 2008 06:52 I am looking for a way of doing a bulk search/replace of email addresses in our store of Word documents. Currently they have @mydomain.co.uk addresses and I want to search & replace with @mydomain.com I did a bit of experiment with UltraEdit32 on some sample docs and altough it finds and replaces all occurances of the string the docs then cannot be opened by Word. I suspect that there is some arithmetic checksum embedded in the docs and Word wasn't happy as this wouldn't resolve correctly. I could get the users to do it one-by-one but there are many hundreds of templates and standard letters/documents that get emailed/posted out to clients. In some cases the email addresses are in the body of the docs and some have them in text-boxes as part of header/footers. To go through each individual document will take weeks so I am trying to find a better way of doing it. I am aiming to keep the replacing string the same physical length as the original by adding a space at the end. If anyone has any suggestions I'd be greatly obliged. Maurice Reed IT Manager International House London
From: Maurice on 13 May 2008 06:26 Well I am amazed that nobody came up with any ideas for this...... Anyway I have fixed it. After some more testing I realised that as I was replacing .co.uk (6chars) with .com (4chars+1 space) that the edited doc was a few characters shorter and this was throwing Word off. I tried again but replaced .co.uk with .com (4chars+2 spaces) and this worked fine. "Maurice" wrote: > I am looking for a way of doing a bulk search/replace of email addresses in > our store of Word documents. Currently they have @mydomain.co.uk addresses > and I want to search & replace with @mydomain.com > > I did a bit of experiment with UltraEdit32 on some sample docs and altough > it finds and replaces all occurances of the string the docs then cannot be > opened by Word. I suspect that there is some arithmetic checksum embedded in > the docs and Word wasn't happy as this wouldn't resolve correctly. > > I could get the users to do it one-by-one but there are many hundreds of > templates and standard letters/documents that get emailed/posted out to > clients. > > In some cases the email addresses are in the body of the docs and some have > them in text-boxes as part of header/footers. To go through each individual > document will take weeks so I am trying to find a better way of doing it. I > am aiming to keep the replacing string the same physical length as the > original by adding a space at the end. > > If anyone has any suggestions I'd be greatly obliged. > > Maurice Reed > IT Manager > International House London
From: Bob I on 13 May 2008 08:24
UltraEdit32 isn't part of Microsoft Office so is somewhat difficult to recommend how you use it. Maurice wrote: > Well I am amazed that nobody came up with any ideas for this...... > > > Anyway I have fixed it. After some more testing I realised that as I was > replacing .co.uk (6chars) with .com (4chars+1 space) that the edited doc was > a few characters shorter and this was throwing Word off. I tried again but > replaced .co.uk with .com (4chars+2 spaces) and this worked fine. > > > > "Maurice" wrote: > > >>I am looking for a way of doing a bulk search/replace of email addresses in >>our store of Word documents. Currently they have @mydomain.co.uk addresses >>and I want to search & replace with @mydomain.com >> >>I did a bit of experiment with UltraEdit32 on some sample docs and altough >>it finds and replaces all occurances of the string the docs then cannot be >>opened by Word. I suspect that there is some arithmetic checksum embedded in >>the docs and Word wasn't happy as this wouldn't resolve correctly. >> >>I could get the users to do it one-by-one but there are many hundreds of >>templates and standard letters/documents that get emailed/posted out to >>clients. >> >>In some cases the email addresses are in the body of the docs and some have >>them in text-boxes as part of header/footers. To go through each individual >>document will take weeks so I am trying to find a better way of doing it. I >>am aiming to keep the replacing string the same physical length as the >>original by adding a space at the end. >> >>If anyone has any suggestions I'd be greatly obliged. >> >>Maurice Reed >>IT Manager >>International House London |