UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> mail merge query missing    
 
   
tshudt
post 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
Go to the top of the page
 
+
Peter46
post 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?
Go to the top of the page
 
+
tshudt
post Mar 25 2008, 11:16 AM
Post #3

UtterAccess Veteran
Posts: 338
From: NY



Yes I have I input boxes in the criteria
Go to the top of the page
 
+
Peter46
post 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.
Go to the top of the page
 
+
tshudt
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 10:43 AM