Thread: Signatures in multiple documents
2009-12-07, 11:18 #1
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 42 Times in 42 Posts
A client has asked what the best way is to change the signature line in some 300+ Word letters as the person's signature changes each year. One approach would be a brute force macro that swept through all the documents and changed them. Another would be to modify all of the documents to use a Quick Parts approach, but that requires the user to type something at the end of the letter, and many simply get addressed and printed. A third approach would be to include some sort of signature document at the end with the current person's signature. Note that the signature may or may not contain a digitized signature.
What have others experience been in doing this sort of thing, and what other approaches have been tried?Wendell
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2009-12-07, 12:09 #2
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 93 Times in 89 Posts
Perhaps an AutoOpen macro or event handler in a global template -- to detect and fix any existing signature -- would be easiest. I realize that isn't as forward looking as your suggestions, but it would at least stop the bleeding until the document automation team arrives.
2010-01-09, 19:59 #3
- Join Date
- Dec 2009
- Dallas, Texas, USA
- Thanked 5 Times in 5 Posts
However, another possibility would be that the underlying template includes a link to an external file that always contains the current signature. The external file could be another Word document, which could, itself, contain the digitized signature image. In that way, the update is quite simple; replace the external file.David Gray, Chief Wizard
Irving, Texas, USA
WizardWrx Web - Technical Articles and Free Software
You are more important than any technology we may employ.