Accomplish a Form to Create a Letter?

[matrix1108]

Hi guys!

I hope you guys can help me out here. I want to do a letter generator. Here is the simple version of it:

The user will be presented with an interface (probably a Word file with a table, or an Excel file) with the following blanks to fill in:
NAME: ________
AGE: ___________
ADDRESS: ________

The user will then fill up the blanks, then press a button (or a hotkey) then a word file will be created with the following text:

Hi, <NAME>! I know you are <AGE> years old now. Do you still live in <ADDRESS>?


(I know my example sounds ridiculous but that's just to give you the idea of what I want to happen. LOL)

So basically, data from a form will be used in a word file. Is this possible? What should I be looking at, Macros? I'm familiar with doing macros in Excel but not yet in Word.

Hope someone can help me! Thanks.

[mrice]

From Excel you could try

Please Login or Register  to view this content.

You need to make a reference to the Word object library - Tools - References - Microsoft Word nn.0 Object library