Add data from two Excel Files to Word Doc Template

macropod · #5 04-10-2016, 04:23 PM

While it is possible to use a mailmerge with two or more source files, doing so isn't something that seems appropriate to your situation. I'd suggest employing a user-form with listboxes that you can populate from each of the source workbooks. Once the client and hospital are selected, a command button could be used to populate bookmarks in the document. For some code to populate userform listboxes from an Excel data source, see: http://www.gmayor.com/Userform_ComboBox.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge the data from different excel files.	Sandhya	Excel Programming	2	10-10-2015 02:53 PM
Data Import from multiple word files into an Excel tale	asmanokhchi	Word	1	04-21-2015 06:24 AM
Looking for Advanced Excel training books with tutorials and data files.	thousman	Excel	1	04-02-2014 12:16 PM
Downloading data from AS400 to Excel template	Milney01	Excel	2	06-29-2012 12:06 AM
Excel 2007 template that updates other files?	joelas	Excel	0	01-24-2012 07:12 AM