Solved

Update mail merge source in Word 2007

Posted on 2011-09-26
2
226 Views
Last Modified: 2012-05-12
I recently moved from Windows XP to Win7, and simultaneously from Office XP to Office 2007. Because I've changed the Windows version, all my files are now in a different location, which breaks all of my mail merge documents (since the source location is a fully-qualified path, rather than relative).

When I open a mail merge document (.doc, FWIW), I get the error message that the source document (an Excel .xls spreadsheet) can't be found ("not a valid path," since the prior folder location no longer exists). I can specify the new location, and the merge works correctly. But it isn't saved; indeed, I get an error message asking for the source even while I'm saving the merge document, and then when I reopen, it starts all over again.

I don't want to remove the source from the mail merge document, because then I'll lose all the merge formatting, some of which is rather complex (If/Then, etc.). How can I get the updated source location to be saved permanently?
0
Comment
Question by:ElrondCT
[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 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 36708244
It isn't clear whether you save the main document after you have navigated to the current datasource. If not then do so.

You should be able to remove the source, e.g. by selecting 'Normal Word Document' in the 'Start Mail Merge' dropdown. The fields on your document won't disappear. You can then set it to 'Letters' and find the new datasource via 'Select Recipients', 'Use Existing List...'

Make a backup save if you are worried about losing the settings.
0
 
LVL 20

Author Comment

by:ElrondCT
ID: 36709771
Yes, of course I'm saving the main document after resetting the source. As I said in my second paragraph, "I get an error message asking for the source even while I'm saving the merge document."

But your method of removing and restoring the source worked correctly, and all the fields and settings seem to be normal. Thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

751 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