Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    UK, Surrey
    Thanked 0 Times in 0 Posts

    Choosing sender for letter (Office Word 2003 VBA)

    I have set up several template letters using macros to enter bits of information.

    We have now merged offices, and several of us want to use the same letter, but to be able to put our own name, job title, and email address into various places.

    Can anybody tell me where I can find guidance on putting something into the AutoNew macro that would prompt to ask which person'd details to use, ideally using a drop-down list or similar?


    Peter English

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Choosing sender for letter (Office Word 2003 VBA)

    See <post#=381330>post 381330</post#> for an example. When the user creates a new document, a userform is displayed with text boxes and dropdown lists.

    In <post#=259183>post 259183</post#>, you'll find an example with a simpler userform that demonstrates how to store the values for later redisplay.

Posting Permissions

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