Accomplish a Form to Create a Letter?

**matrix1108** · 04-17-2012, 11:52 AM

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** · 04-17-2012, 12:05 PM

From Excel you could try

Sub CreateWordDocuments()
Const TargetFolder = "C:\temp\"
Dim WordApp As Word.Application
Dim WordDoc As Word.Document

Set WordApp = New Word.Application
WordApp.Visible = True
WordApp.Documents.Add
Set WordDoc = WordApp.ActiveDocument
WordApp.Selection.TypeText Text:="Hi, " & Range("B1") & "! I know you are " & Range("B2") & " years old now. Do you still live in " & Range("B3") & "?"
WordApp.Selection.TypeParagraph

Set WordApp = Nothing
End Sub

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