Using Access Query as a Word Mail Merge Data source

I am trying to set-up a mail-merge in Word, using an Access query as the data source.  When I give the command to choose the data source the query is not listed.  How can this be?

The query has calculated fields, but otherwise is just a SELECT.  I have also tried creating a Select query based on the query doing the calcs, but that isn't shown either.

I am doing this via Remote Desktop Connection - would the indexing just be slow?

Thanks
LJKMartinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
HI,

First you have selected the Access file and then at the Select Table Dialog your query does not appear?

Right?

Regards
0
GrahamSkanRetiredCommented:
If the Access and Word applications, the database and the document are all on the same system, I don't see that affecting the indexing performance,

Just to be clear, do you mean that the query doesn't appear in the Select Table dialogue? Do any queries?
0
LJKMartinAuthor Commented:
Hi,

The Select Table dialog box appears with lots of queries listed, but not the one I want.

Does it list a maximum number?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

GrahamSkanRetiredCommented:
I don't think there's likely to be a numerical limit. The dialogue seems to list queries and then tables, each group in its own numerical order, so you should be able to see where the query would appear in the list.

I seem to recall that OLE DB has some trouble seeing  Select queries with particular characteristics - Union queries and some with particular calculations come to mind (you have mentioned calculated fields).
0
pdebaetsCommented:
There are security issues that can prevent queries (maybe just parameter queries? I forget) from appearing in the word mail merge selection. You may want to consider running a make-table query in code just prior to running your mail merge, then specify the table you made as the mail merge record source.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GrahamSkanRetiredCommented:
Also, if you are using Office version from 2002 to 2007 inclusive, you might find that using DDE helps.
Prior to 2002, DDE was the default connection method. After 2007 it is no longer available.
0
LJKMartinAuthor Commented:
I am using Office 2010.

I've changed the query to Make Table, and that will work just as well for the user.  Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.