Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Poole, UK
    Posts
    95
    Thanks
    22
    Thanked 2 Times in 2 Posts
    Can anyone help me with this problem that I have suffered for a long time. I frequently use Word (both 2002 and 2003) to produce mail merge documents where the data source is an Excel spreadsheet (located in another folder on the same drive). This works very well and I always save the Word file when I finish using the document.

    However, when I reopen the Word document I always get an error message which says it cannot find the data source, and so I have to manually navigate it back to the right file.

    How can I get word to remember the data file location?

    Any ideas? Thanks.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Are you saving the Main Merge document after you have connected to the data source and performed the merge? If so, Word should remember the data source the next time you open the document.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    Poole, UK
    Posts
    95
    Thanks
    22
    Thanked 2 Times in 2 Posts
    Yes, I always do that. That's the funny thing!

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Are the Excel files by chance on a network drive where the might be a permissions issue? That's about the only reason I can think of where Word would fail to find the files. Another option you might try is to actually create a saved Data Source. That gets stored in your documents folder in the "My Data Sources" folder, and will have an appropriate file extension. You didn't specify what version(s) of Windows you are using, but that should work for XP, Vista or Win7.
    Wendell

  5. #5
    Star Lounger
    Join Date
    Dec 2009
    Location
    Poole, UK
    Posts
    95
    Thanks
    22
    Thanked 2 Times in 2 Posts
    Thanks. I was using one of the mail merge documents today (XP Pro and Office 2003) and the data spreadsheet is actually in the same folder as the document! However, the system always asks me to find the data source (starting at the 'my data sources' folder) when I open the document. Looks as if I'll just have to live with it, although I guess if I put a shortcut to the appropriate folder in the 'my data sources' folder, that will perhaps save me some navigation time!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •