Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-25-2021, 12:20 PM
MCA MCA is offline Form to populate text in a word document Windows 10 Form to populate text in a word document Office 2019
Novice
Form to populate text in a word document
 
Join Date: Feb 2021
Posts: 1
MCA is on a distinguished road
Exclamation Form to populate text in a word document

I'm wondering if it is possible to create a form in Excel that could be used to populate a Word document and/or add sections to a Word document text that can be populated by data entered into the form.

I have scientific technical specification documents that have multiple sections and not necessarily all of them are used for a technical document (i.e., sections can very). I would like to be able to "toggle on" sections that I'd like to show in the document and also be able to populate the document with depths, diameters, weights, rates, etc.

For example, the form would have Sections 1 through 10, but all I need this time are Section 1, 2, 5, 6, 7, and 9. Those text sections toggled on in the form and would then be populated within the Word document.



Within those text sections, there will be depths, diameters, weights, etc. that can also be filled out in the form and need to be populated with the selected sections in the text of a section or multiple sections.

I'm thinking of being able to create these text documents on the fly or change them on the fly based on what is either selected (toggled on) or data is entered.

Is this something that can be done? If so how?
Reply With Quote
  #2  
Old 02-25-2021, 04:17 PM
Guessed's Avatar
Guessed Guessed is offline Form to populate text in a word document Windows 10 Form to populate text in a word document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Yes it can be done. It is complicated though and there are VERY different ways to achieve the aim.

If you don't have vba coding experience, the best method would be to explore mail merge. I would recommend you start by collating the excel data by creating a new worksheet where ALL of your Excel inputs needed for Word are in a single table with a column for every field. You can then link your Word document to this table and place the fields into that Word doc.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-25-2021, 09:55 PM
gmayor's Avatar
gmayor gmayor is offline Form to populate text in a word document Windows 10 Form to populate text in a word document Office 2019
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

Personally I would create a userform in a Word template, from which the relevant sections can be selected and then use that to build the document from the Excel data. As Andrew implies, this is not a job for a beginner in VBA. Create a userform will help with the basics.
__________________
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form entries to populate in a text template lordbodom Word 1 07-31-2020 11:28 AM
Possible to create a user form and populate it with a field from the main document? NMGMarques Word 3 02-12-2020 06:08 PM
Form to populate text in a word document Creating a Form with Fields that will Populate into Another Document Mobius Word 3 05-06-2016 12:46 AM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
Auto populate a word document anadmin Word 0 08-05-2011 07:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


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