My Assistant
![]() ![]() |
|
|
Mar 25 2008, 10:44 AM
Post
#1
|
|
|
UtterAccess Veteran Posts: 338 From: NY |
Hello, I have just upgraded from office 2000, to 2007. I have a database with some mail merge documents . When I try to reset the merge information locate the proper query, the query does not show up in the list. Some of the queries do though, but not all of the them. If is very frustrating, as they worked fine in 2000. Any help would be greatly appreciated.
thanks Tim |
|
|
|
Mar 25 2008, 11:15 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 7,394 From: Oadby Leics, UK |
Are the missing queries parameter queries by any chance?
|
|
|
|
Mar 25 2008, 11:16 AM
Post
#3
|
|
|
UtterAccess Veteran Posts: 338 From: NY |
Yes I have I input boxes in the criteria
|
|
|
|
Mar 25 2008, 11:29 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 7,394 From: Oadby Leics, UK |
Then I'm afraid things have changed rather a lot.
The (current) default connection in Word to Access does not permit the use of parameter queries as data sources. You have to force Word to use the older (more useful but now hidden) connection method called DDE. There is a description of what to do in A2003 here: http://www.taznetworks.com/rss/2004/11/acc...-word-mail.html I haven't used the feature in Off2007 so I can't say for certain that it still works as described; I wouldn't be surprised if the dialogs don't match exactly so you might have to do a bit more experimenting. |
|
|
|
Mar 25 2008, 11:54 AM
Post
#5
|
|
|
UtterAccess Veteran Posts: 338 From: NY |
Thanks Peter, that information worked great!!!!!
Thanks again Tim |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 10:43 AM |