Perhaps this is not the proper Forum for this (and someone may be so kind as to re-direct me).

I have an .MDB that is set up to send information to a series of Word Templates through Mail Merge. We have had a series of changes in our leadership (with more to come) and our letterhead changes frequently. I would like to store the names of the individuals in leadership in a table in my MDB and then bind/link the fields in the template where individuals names go to the table. All the templates are already linked to other data tables, so I need to find a way to attach a second data source (preferably from the mdb)to the Templates. Then as changes in leadership occur, I can rapidly update all the Templates.

I've tried looking for something similiar to DLOOKUP in Word- no luck. And the data tables the leaders would be listed in are not related to the tables that provide to the OpenDataSource for the Mail Merge (so if I included them into the query it would produce a cartesian product.)

Any ideas as to how to do this or what I should research?

Thank You,

Loralee

You can add the leadership to each field in the append/update or make table query you use for your Mail Merge tables. If the field is only pulled once at the top of the page for example, it won't matter that it is returned in each record since it won't be pulled on the form letter. In fact, it will be pulled once for each letter, so it will be used once for each letter. So that should work fine.

So if you add the leadership field to the mail merge tables, and then modify your form letters slightly, this should work. I don't think you need to do a second data source. Once you modify the table and open your Word mail merge doc, the field should show up in your current data source. Use it as often as you need it.

HTH



mmcdonal

Thanks, I didn't think this one through the whole way.

Loralee