Any way to use more than one source when merging DBs into Word?

Factual Questions
1

I’m using Word (2007) to merge a username/password spreadsheet into a word file and then using that Word document to query for individuals, then print out their information. However, we have more than one set of systems with unique logons that our users need. The problem is that those systems have seperate information dumps/DBs that can’t really be integrated with each other, so the information is all over the place.

My question is if it’s possible to use the MS Word (2007) merge function to pull data from several sources or, if that’s not possible, if there are any other programs out there that can do this?

2

I doubt that Word can do it - it might be easier to use something like MS Access to combine the two sources via a query and then get Word to link to that query…

3

I’m looking into consolidating it, but I haven’t received system dumps from the other services yet. I’m afraid there might not be an unique ID for the entries, so that they’d have to be manually compiled.