Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2010, 05:43 AM
amarsha4 amarsha4 is offline Word (Mail Merge) Refreshes Query Too Often! Windows XP Word (Mail Merge) Refreshes Query Too Often! Office 2003
Novice
Word (Mail Merge) Refreshes Query Too Often!
 
Join Date: Nov 2010
Posts: 2
amarsha4 is on a distinguished road
Default Word (Mail Merge) Refreshes Query Too Often!

Hi there,



I'm new to the forum, I hope someone can help me.

I have quite a complex Access query that I connect to from Word. The query takes about 20 seconds to load, which is fine when loading up my Word document to compile a batch of letters.

The problem is that the query is being refreshed by Word a lot more frequently than I require. The query is refreshed:

· On closing the 'Mail Merge Recipients' dialog box.
· On switching back to the merge document, after viewing another Word document.

Is there any way I can limit the frequency at which the query is refreshed? I spent a lot of time on this document, which now automates a lot of my job, the problem is that waiting for the query to refresh every time is making it counter-productive!

I don't really want to copy the query to an Excel document every time I do a batch of letters. I realise that this would solve the problem, however, it would take some of the elegance out of the process.

Hope someone can help!

Thanks,

Andy
Reply With Quote
  #2  
Old 11-10-2010, 09:12 AM
amarsha4 amarsha4 is offline Word (Mail Merge) Refreshes Query Too Often! Windows XP Word (Mail Merge) Refreshes Query Too Often! Office 2003
Novice
Word (Mail Merge) Refreshes Query Too Often!
 
Join Date: Nov 2010
Posts: 2
amarsha4 is on a distinguished road
Default

Shameless self-bump.
Reply With Quote
Reply

Tags
access, mail merge, query

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word (Mail Merge) Refreshes Query Too Often! I need MS Word Mail Merge Help! mikecincotta Mail Merge 1 10-04-2010 05:22 PM
mail merge from access query or two tables peter Mail Merge 0 08-24-2010 05:32 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
mail merge in word help jngovols Mail Merge 0 04-07-2008 05:40 AM
Word (Mail Merge) Refreshes Query Too Often! Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft