Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2016, 02:49 PM
Mobius Mobius is offline Creating a Form with Fields that will Populate into Another Document Windows 10 Creating a Form with Fields that will Populate into Another Document Office 2016
Novice
Creating a Form with Fields that will Populate into Another Document
 
Join Date: May 2016
Posts: 1
Mobius is on a distinguished road
Cool Creating a Form with Fields that will Populate into Another Document


I use multi-page contracts that contain a large amount of boilerplate text. However, there are places where names, addresses, reference numbers, etc. need to be inserted. Is there a way where I can create a "form" with all of the input data, then with some mail merge-style facility have my contract automatically populate with all of the appropriate data? I am sure there is a tutorial out there, but I just don't know how to articulate my question appropriately.
Reply With Quote
  #2  
Old 05-05-2016, 09:50 PM
gmayor's Avatar
gmayor gmayor is offline Creating a Form with Fields that will Populate into Another Document Windows 10 Creating a Form with Fields that will Populate into Another Document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

What you need is a VBA userform. This is not exactly the easiest thing to begin an interest in VBA programming with, however - For the basics, see http://www.gmayor.com/Userform.htm and http://www.gmayor.com/Userform_ComboBox.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-05-2016, 10:50 PM
macropod's Avatar
macropod macropod is offline Creating a Form with Fields that will Populate into Another Document Windows 7 64bit Creating a Form with Fields that will Populate into Another Document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

An alternative would be use an actual mailmerge with and Excel data source, having standard column header names that the various output documents, configured as mailmerge main documents, can reference. If you store the data in the Excel workbook as permanent records, that would allow you to process multiple records at a time and gives you boilerplate text you can copy to new rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-06-2016, 12:46 AM
Charles Kenyon Charles Kenyon is offline Creating a Form with Fields that will Populate into Another Document Windows 8 Creating a Form with Fields that will Populate into Another Document Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Mobius View Post
I use multi-page contracts that contain a large amount of boilerplate text. However, there are places where names, addresses, reference numbers, etc. need to be inserted. Is there a way where I can create a "form" with all of the input data, then with some mail merge-style facility have my contract automatically populate with all of the appropriate data? I am sure there is a tutorial out there, but I just don't know how to articulate my question appropriately.
I do use Mail Merge for this. Essentially it is a DIY case management system. I keep the data for many (similar) cases in an Excel spreadsheet. I use that as the data source. I merge standard documents with a single case record to form a draft document for filing with the court. In many, but not all, situations, the draft is the final document. In others it is fine-tuned to the situation.

I do not, but probably should, use a UserForm in Excel to populate the data rows.
Reply With Quote
Reply

Tags
forms, merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Form with Fields that will Populate into Another Document Creating fields in a document that can be imported by Excel brucemc777 Word 4 01-19-2016 11:14 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Creating a Form with Fields that will Populate into Another Document Creating a new document from a template screws up fields! Cosmo Word 6 08-07-2014 05:16 AM
Using form to populate additional fields hmccain Word 0 12-09-2013 11:15 AM
Auto-populate from form fields kenelder Word 3 05-23-2013 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft