Solved

Why is my datasource path being 'lost' when using Word 2007 Mailmerge and datasource on a Network drive.?

Posted on 2009-07-12
3
318 Views
Last Modified: 2012-05-07
Since my PC has been upgraded to Word 2007, I have some problems with CSV mailmerge data sources stored on a network drive, which worked fine with word 2003.
My existing mailmerge documents now report 'Data source can not be found' after the SQL statement and I have to locate the data source and even though I save the mailmerge document, I still have to manually link the data source every time time. New Word 2007 mailmerge documents that have data sources from the network drive appear not to save any link at all. When I re-open  the mailmerge document, there is no SQL statement and it is just like a normal word document - so again the data source has to be found and opened manually via the mailmerge options.
After some experimenting, I found that the mailmerge data source links will save perectly on my C: drive - however I would like to solve the problem of why this doesn't work on the network !
0
Comment
Question by:Callao
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
Joanne M. Orzech earned 500 total points
ID: 24840663
Although I realize the KB I'm linking to refers to an earlier version, I am posting anyway - I think it's still applicable... I would try adding your network locations to trusted locations in IE.

http://support.microsoft.com/default.aspx/kb/834699

 
Method 1: Trust the location in Internet ExplorerTo trust the location where your data source is located on your intranet, follow these steps: Start Internet Explorer.  
   
On the Tools menu, click Internet Options.  
   
On the Security tab, click Local intranet, and then click Sites.  
   
In the Local intranet dialog box, click to select each of the three following check boxes as appropriate, and then click OK: Include all local (intranet) sites not listed in other zones.  
   
Include all sites that bypass the proxy server.  
   
Include all network paths (UNCs).  
   
Note If your data source is in a location that is not covered by any one of these three check boxes, click Advanced, and then add the Web site that contains your data source.  
   
Click OK to close the Local intranet dialog box.  
   
Click OK to close the Internet Options dialog box.  
0
 

Author Closing Comment

by:Callao
ID: 31602632
Many thanks - I will try this and see if this works!
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24841720
Oh - well Callao - you shouldn't have accepted my answer until you've tested it and are sure that it works... let me know if it doesn't work, and I can unaccept your answer for you and perhaps other experts have thoughts.

Joanne Orzech
MS Word MVP
EE Zone Advisor
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question