Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Update mail merge source in Word 2007

Posted on 2011-09-26
2
Medium Priority
?
238 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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

886 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