Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2015, 02:43 PM
yajnaval yajnaval is offline Fill MS-Word docs/forms with name address data from external source Windows 8 Fill MS-Word docs/forms with name address data from external source Office 2010 64bit
Novice
Fill MS-Word docs/forms with name address data from external source
 
Join Date: Feb 2015
Posts: 1
yajnaval is on a distinguished road
Default Fill MS-Word docs/forms with name address data from external source

In MS Word 2003 onwards, what is the easiest way one can one pre-fill MS-Word forms with externally supplied data?


For instance, there are 7 forms published by a small claims court. Is it possible to fill the documents with entries supplied from some other source (example a text file) i.e. address in the address field, phone number in phone number field etc.
Reply With Quote
  #2  
Old 02-14-2015, 05:11 PM
Charles Kenyon Charles Kenyon is offline Fill MS-Word docs/forms with name address data from external source Windows 7 64bit Fill MS-Word docs/forms with name address data from external source Office 2010 32bit
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

The simplest way is probably MailMerge.
Reply With Quote
  #3  
Old 02-14-2015, 10:48 PM
gmayor's Avatar
gmayor gmayor is offline Fill MS-Word docs/forms with name address data from external source Windows 7 64bit Fill MS-Word docs/forms with name address data from external source Office 2010 32bit
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

The short answer to the question is yes. You can read the data from an external source. Excel is probably the simplest. You can read the name and address data from a worksheet into an array (or into a list or combo box in a userform) and interrogate the array for the data. Tell us more about what you have and what you want to read.
__________________
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
Fill MS-Word docs/forms with name address data from external source Fill In PDF Forms with Word dlowrey Word 2 09-24-2012 09:55 PM
Fill MS-Word docs/forms with name address data from external source drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Fill MS-Word docs/forms with name address data from external source vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
Fill MS-Word docs/forms with name address data from external source Refresh of data from external source Jirik61 Excel Programming 3 07-13-2012 01:40 PM
Fill MS-Word docs/forms with name address data from external source Fill-in forms using Word Tables BigJspice Word Tables 3 06-25-2012 07:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 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