Re: Find Merge Datasource

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alphonse Giambrone (NOSPAMa-giam_at_example.invalid)
Date: 04/23/04


Date: Thu, 22 Apr 2004 22:11:10 -0400

Cindy,

Thanks for the info. Sorry for misstatement. I did not mean that it is
common for a query to be deleted, but rather that the data source set in the
doc might be invalid for any reason like path changes, source (including
query)deletion, etc.
In this particular case it was apparently a digruntled former employee who
managed to get into system remotely and do some damage. Unfortunately for
client (brand new for me) they had no usable backup of database.

-- 
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Cindy M -WordMVP-" <C.Meister-C@hispeed.ch> wrote in message
news:VA.0000961e.0126b9c4@speedy...
> Hi Alphonse,
>
> > I would would think that the problem would be very common and that as
> > popular as Word Merge is MS would provide a way of extracting/relinking
> > without requiring a connection to the original datasource.
> >
> Well, I'm not so sure that the query in an Access file getting deleted is
> all too common :-) FWIW, Word's mail merge feature is some fifteen years
> old; back then, there weren't too many data sources to choose from...
> Anyway, they just designed the binary structure of a Word document such
> that, if you don't link up a data source, the document is no longer a
> merge document, and therefore the information is no longer in the
> document.
>
> In the newest version of Word, using automation (VBA/macro) you can
> relink to a datasource without having to go through the message box hoops
> if something goes wrong. But there's no way to extract this information
> from an unopened file (unless it's been saved in 2003 in WordML (XML
> format)).
>
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
> http://www.word.mvps.org
>
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
>


Relevant Pages

  • Re: Repeat a merge if a record exists or end if it doesnt
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... Doug Robbins - Word MVP ... I am trying to make a document in which my data source is a .txt ... generated from an access query and exported. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge problem with Access DB
    ... Did you save the document after re-attaching the data source? ... Please reply to the newsgroup unless you wish to avail yourself of my ... query again for merging with Word, I get the same results. ... data, the query will retrieve it, but Word will not populate the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Repeat a merge if a record exists or end if it doesnt
    ... I changed the document type to a directory and deleted the fields that i ... Please reply to the newsgroup unless you wish to avail yourself of my ... I am trying to make a document in which my data source is a .txt document ... generated from an access query and exported. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge problem with Access DB
    ... You need to re-attach the data source to get the option of how the ... Please reply to the newsgroup unless you wish to avail yourself of my ... any criteria in the query. ... data, the query will retrieve it, but Word will not populate the data. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Error opening document template
    ... but doing so gives the following error: "The query condition you are ... > However, this is a new document, so there is not a data source and I simply ... OPEN the template. ... reply in the newsgroup and not by e-mail :-) ...
    (microsoft.public.word.mailmerge.fields)