Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2015, 01:13 PM
jjfromnj jjfromnj is offline Creating Word document that automatically inputs text into applicable fields, Windows 8 Creating Word document that automatically inputs text into applicable fields, Office 2010 64bit
Novice
Creating Word document that automatically inputs text into applicable fields,
 
Join Date: Dec 2015
Posts: 1
jjfromnj is on a distinguished road
Default Creating Word document that automatically inputs text into applicable fields,

I work for a local government agency and, perhaps not so surprisingly, the inefficiency is mind boggling. I interview clients all day long and have to fill out about a dozen forms per client. These forms are all saved individually as Word files. They have pre-formatted text that is uneditable with blank text fields where I manually input the client's details. So I manually type in the client's name, date, address, SSN, case number, etc. multiple times across the dozen or so forms. God damn is it excruciatingly inefficient.

What I want to do is create a single Word document that includes all 12 of these forms. I want to type in each piece of info once and have Word automatically input the info into all applicable fields throughout all the forms. I also want Word to automatically input the current date where applicable.

There are also a couple forms which I only use occasionally. Is there any way to exclude these from the standard file i'm trying to create by default but leave it as an option to include them (and also automatically populate their applicable fields)?

Surely this is possible, right? I've tried bringing my idea up to my administration and IT department and they basically told me to **** off. Your tax dollars at work!
Reply With Quote
  #2  
Old 12-03-2015, 04:23 PM
macropod's Avatar
macropod macropod is offline Creating Word document that automatically inputs text into applicable fields, Windows 7 64bit Creating Word document that automatically inputs text into applicable fields, Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
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

See: http://gregmaxey.com/word_tip_pages/repeating_data.html

As for your occasional forms, you could add macros to those to pull the required data from the corresponding regular form.

Somehow I doubt my tax dollars have anything to do with this...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-03-2015, 10:09 PM
gmayor's Avatar
gmayor gmayor is offline Creating Word document that automatically inputs text into applicable fields, Windows 7 64bit Creating Word document that automatically inputs text into applicable fields, Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
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 ofgmayor has much to be proud of
Default

Greg's web page may help, but personally I would create a userform to select the forms required and input the common data, then open and write the data to each of the documents, save and close them. There is no need to combine them, unless you particularly wish to do so and it may create formatting issues if you do.
For the basics, see http://www.gmayor.com/Userform.htm
__________________
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
  #4  
Old 12-04-2015, 10:00 AM
Charles Kenyon Charles Kenyon is online now Creating Word document that automatically inputs text into applicable fields, Windows 8 Creating Word document that automatically inputs text into applicable fields, Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,462
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

I agree with Graham's suggestion as being the most elegant. It will be a matter of identifying the spot in the documents you want the information stored. These may well have bookmarks already if they are legacy Word forms.

A less elegant solution would be mail merge, but that would require that on some level you have the ability to edit the forms you are filling in to turn them into primary merge documents with merge fields. Mail merge requires less technical ability than does vba for a userform, IMHO. However, getting permission to alter government forms (even if not changing layout or text) may require more than you can deal with.

Note, I regularly modify non-modifiable government forms to make them mail merge, but I don't work for the government. If what they want is the paper result, it shouldn't matter to them.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Word document that automatically inputs text into applicable fields, Creating a table that automatically updates based on entries of a heading in the document cahphoenix Word 3 10-29-2014 01:11 PM
Creating Word document that automatically inputs text into applicable fields, Creating a new document from a template screws up fields! Cosmo Word 6 08-07-2014 05:16 AM
Creating Word document that automatically inputs text into applicable fields, Automatically updating document as fields are completed. Calab Word 2 06-27-2013 08:55 AM
Does Word have an option to update fields AUTOMATICALLY at open??? Jamal NUMAN Word 17 01-27-2012 12:57 AM
Linking Text Fields in a document in Word 2007 lcolson Word 0 12-22-2008 05:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.


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