Don't know if this is possible, but if it is, any pointers/advice would be appreciated.

I have a Word 2003 userform which contains an address block, comprising several textboxes. What I am considering is:

  1. Whilst the userform has focus, somehow using Words mail merge feature (or similar) to select an address from a spreadsheet and add it to the userform. When the userform is in use the spreadsheet will not be open.

  2. If the address is not in the spreadsheet I want to be able to add the address manually and check a box to save the address details to the (unopen) spreadsheet when the userform exits.

Any ideas?