Solved

Update mail merge source in Word 2007

Posted on 2011-09-26
2
221 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
Comment Utility
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
Comment Utility
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 your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
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…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now