Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word97: How to fill a document template using a userform?

Status
Not open for further replies.
Katerine

Katerine

Programmer
Joined
Mar 9, 2001
Messages
234
Location
US
Hi all,
I apologize for what is probably a ridiculously simple question. I'm a relative newcomer to Word VBA (I've been programming in Access for a couple years now), and I need to update some templates.

Imagine something like your manual tax return. That's kind of what these templates look like: they contain a lot of text, and a lot of table fields and "fill-in-the-blank" areas. All of the text is written into the template itself, but the data needs to be filled in by code, after the user inputs it into a userform.

Currently, all of the areas that require data (about 40 of them) have unique mailmerge fields in them. At the end of the data-entry, the user clicks a "continue" or "finish" button, which adds MailMerge sets to the document based on the data in the form.

This works, but it seems like there should be a much easier way to do it to me. One that doesn't require hard-coding over 40 mail-merge names into the code. So I'm looking for a better way. It just seems like there should be a much more direct way of adding data to a document than this. Or isn't there? :-I

Thanks in advance for any help you can provide! :-)
 
Sort by date Sort by votes
I have never used Mail merge so I don't really know what it does, but if I was going to populate field from a userform I would just put Labels on the Document then fill them from VB.

ThisDocument.Label1.Caption = TextBox1.Text

Let me know if this isn't what you are looking for.
 
Upvote 0 Downvote
Another way you can do it is to have Tables on your document and populate the cells of the tables.

This method would allow the user to change the fields after the Userform has closed.

This bit of code creates a table and populates two cells with data.

Private Sub AddTable()
Set myTable = ActiveDocument.Tables.Add(Selection.Range, 3, 3)
With myTable
.Cell(1, 1).Range.InsertAfter "First Cell"
.Cell(myTable.Rows.Count, myTable.Columns.Count).Range.InsertAfter "Last Cell"
End With
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Outlook Template replace text
Replies
13
Views
3K
Andrzejek
Andrzejek
huiettcm
  • Locked
  • Question Question
Excel UserForm Window 'Focus' Event Listener
Replies
14
Views
1K
huiettcm
huiettcm
K
  • Locked
  • Question Question
How to resolve define worksheets array
Replies
1
Views
1K
combo
combo
Submeg
  • Locked
  • Question Question
Selecting shapes based on its name and then arranging them in a circle
Replies
2
Views
458
Andrzejek
Andrzejek
AncientTiger
  • Locked
  • Question Question
How to screenshot a userform and save the capture as JPG
Replies
7
Views
3K
AncientTiger
AncientTiger

Part and Inventory Search

Sponsor

Back
Top