Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,483
    Thanks
    3
    Thanked 41 Times in 41 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

  2. 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!

    Excel 2013: The Missing Manual

    + 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!

  3. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    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.

  4. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    111
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by jscher2000 View Post
    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.
    That might actually be the best long range solution, too.

    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
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •