JackOfAllSoftware
Technical User
I am trying to do mail merges using some Word 2002 docs with Access 97 queries. I want to use queries, if possible, to eliminate the need for maintaining temporary tables in Access just for the mail merge.
I cannot change the versions of the software, this is what I have been given to work with.
>>>Question: What are the restrictions on the types of Access queries that can be used as a data source for Word mail merges?
I have tried to use the result of a crosstab query for a mail merge, with no luck... Word does not allow me to select it when I choose my data source. Also, tried to use a Select query as a "wrapper" (referenced the crosstab) for the crosstab query... still no luck.
I have tried to create my query in a different way so that I only have select queries (no crosstabs in the "lineage"
, but I am finding in some situations, that apparently Word won't allow certain select queries to be used. (Unique values=Yes, for example, did not work)
Can anyone tell me what the restrictions are, and how to get around them?
Thanks!
I cannot change the versions of the software, this is what I have been given to work with.
>>>Question: What are the restrictions on the types of Access queries that can be used as a data source for Word mail merges?
I have tried to use the result of a crosstab query for a mail merge, with no luck... Word does not allow me to select it when I choose my data source. Also, tried to use a Select query as a "wrapper" (referenced the crosstab) for the crosstab query... still no luck.
I have tried to create my query in a different way so that I only have select queries (no crosstabs in the "lineage"
, but I am finding in some situations, that apparently Word won't allow certain select queries to be used. (Unique values=Yes, for example, did not work)Can anyone tell me what the restrictions are, and how to get around them?
Thanks!
