Solved

Update mail merge source in Word 2007

Posted on 2011-09-26
2
225 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
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

Suggested Solutions

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
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…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

680 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