Can you mail merge into a Word 2003 userform textbox?
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:
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.
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?
"Those things we must learn to do, we must learn by doing" (or hope somebody else will take pity and help out )
Re: Can you mail merge into a Word 2003 userform textbox?
The spreadsheet will not be open.
What I was hoping to do is add a command button to the userform which, when clicked, will allow the user to select the address somehow. For example, something like the mail merge feature in Word 2003 which presents a list of the details contained in the spreadsheet without actually opening the spreadsheet - see attached.
Any ideas?
"Those things we must learn to do, we must learn by doing" (or hope somebody else will take pity and help out )
Can you mail merge into a Word 2003 userform textbox?
)
Reply With Quote
