Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2004

Tip: Looking for answers? Try searching our database.

Cannot Find Its Data Source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave Foote - 17 Dec 2004 10:23 GMT
We are having trouble with the Mail Merge in WordXP which are on the verge of
rolling out to all of our staff.

Once a document has been created and saved with a mail merge that has been
linked to a data source the document will re-open correctly provided NO
FILTER has been placed on the data source.  If the document is saved with a
filter in place when you re open the document a message of the form:

abc.doc is a mail merge main document.  Word cannot find its data source,
\\aserver\datadir\abc1.xls

(Note this also happens using Access Databases as the data source so is not
an exclusive excel/word issue)

You then have the option to locate the data source or effectively remove all
the header info and so remove all the mail merge functions.

So effectively you have to relocate the data source each time you open the
mail merge document.

Any ides how to correct this?
Peter Jamieson - 17 Dec 2004 10:46 GMT
Yes, it's a pain - although I know for a fact that this problem has been
reported, and I believe it was fixed in Word 2003,  I do not think it has
been fixed in any of the XP service packs. Nor do I know of any workaround,
let alone a simple one. As long as the merge documents are completely
predefined by the IT people, I suppose your best option is to set up the
data source and any necessary filters using an AutoOpen macro, and never let
the user overwrite the original document. If the user need to be able to
save the sorts/filters he/she has imposed, I suspect the only option would
be to run a macro (perhaps an Autoclose macro, though I never feel
particularly comfortable with those) that captures the current querystring,
saves it (e.g. in a document variable), then removes it. Then have an
AutoOpen that re-establishes the sort/filter criteria. But I suspect that
even if that is theoretically feasible it falls foul of another unfixed
error whereby trying to get the value of Querystring causes an error in Word
XP. The only way I know to find that Querystring is to save the document as
a web page, then go and inspect the HTML.Not my idea of a robust solution,
either.

Best I can do I'm afraid.

Peter Jamieson

> We are having trouble with the Mail Merge in WordXP which are on the verge
> of
[quoted text clipped - 21 lines]
>
> Any ides how to correct this?
Dave Foote - 17 Dec 2004 11:11 GMT
Thank you for that Peter.

I had a notion in the back of my mind that it would be a known (reported)
problem although I can't find any reference in the MS knowledge base to it.

I might be able to get round the problem by monitoring for document closure
through a VB .NET addin (event sinking the document close) and then modifying
the or at least storing the datasource requirements in the document
properties as you suggest I'll have an experiment with the QueryString to see
what happens.

Thanks again

Dave Foote

> Yes, it's a pain - although I know for a fact that this problem has been
> reported, and I believe it was fixed in Word 2003,  I do not think it has
[quoted text clipped - 43 lines]
> >
> > Any ides how to correct this?
Peter Jamieson - 17 Dec 2004 11:27 GMT
I suppose it is possible that the Querystring problem (if it exists) is to
do with OLE Automation and that there is another more direct way to get the
value using COM. I've yet to work out exactly what low-level interface .NET
addins use to get these values.

Gotta go now,

Peter Jamieson
> Thank you for that Peter.
>
[quoted text clipped - 75 lines]
>> >
>> > Any ides how to correct this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.