J
jo15765
I know nothing about how the mail merge works...but I use it on
day-to-day basis and was thinking there has to be a better way.
Currently, we have mail merge set up in a Word 2000 document that wil
run a query and pop up a box asking for the ID of the record to pull
the data for that specific record is then pulled into the mapped field
on the "template" that was opened. My question is other than modifyin
the query, or use DAO to pull in the requested fields (Bc it i
different depending on which template I open) or hard coding into th
query, is there a way to pass the ID?
For example, could you use an Excel textbox, and input the ID there, an
then have that passed to the query for the mail merge
day-to-day basis and was thinking there has to be a better way.
Currently, we have mail merge set up in a Word 2000 document that wil
run a query and pop up a box asking for the ID of the record to pull
the data for that specific record is then pulled into the mapped field
on the "template" that was opened. My question is other than modifyin
the query, or use DAO to pull in the requested fields (Bc it i
different depending on which template I open) or hard coding into th
query, is there a way to pass the ID?
For example, could you use an Excel textbox, and input the ID there, an
then have that passed to the query for the mail merge