I have an Excel form that from one texbox will open a word doc. Once the word doc is opened, it runs a mail merge and asks for an input parameter from the access query it is based off of. My question is, How can I pass the value from the Excel form to the parameter window that will display once the word doc has opened?
I know I could re-write the query to accommodate to this, but this is a large scale project, I would have to re-write probably over 1,000 queries, and I don't want to have to do that. And the same situation with, I know I can use Excel to run the SQL behind the query, which that might be a viable option, but would like to steer away from it at this current time since the actual SQL varies depending on certian criteria it is never 100% the same.