View Single Post
 
Old 04-10-2016, 04:23 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote