Recipients List SQL Changes

paul h · #1 10-22-2015, 08:41 AM

I have an Access application that opens up one of 20 different Mail Merge letters. No issues on the Access side. When the Word document opens I get the usual SQL warning, but sometimes i get a second warning with a different (maybe temporary and without a path) filename. I am using RTF files for the merge data. See the examples below.

First (and normal) Warning

Code:

 
 Opening this document will run the following SQL command:
 
SELECT * FROM T:\FITS_2007\Leters\MailMerge\qry_Not_Enough_Info_R.rtf
 
Data from your database will be paced in the document.  Do you want to continue?

2nd Warning

Code:

 
Opening this document will run the following SQL command:
 
 
SELECT * FROM A065428D.rtf
 
 
Data from your database will be paced in the document. Do you want to continue?

From here the document seems to merge correctly with the right data, but I'm concerned that the user may inadvertantly save the Word document while it is pointing at this temp file which will not get updated going forward. So I am wondering why this is happening and how can I prevent it from happening in the future.

Any ideas?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
undisclosed-recipients	iflog	Outlook	8	03-17-2014 05:29 PM
Emails not received by Recipients	dextrousdave	Outlook	1	11-30-2011 12:27 PM
Mail Merge Recipients List	TanMan	Mail Merge	1	10-13-2011 06:36 PM
Distribution list - BC recipients	KeesW	Outlook	0	06-30-2010 09:52 PM
how to hide other recipients?	gerryb	Outlook	2	08-12-2009 09:56 AM