[Chief Gopher]

We have recently moved some files and now when I run a mailmerge that was
set-up to utilise an Access database it can't find the database.

Where do I go to be able to amend the address path ?

---
Christine

[Peter Jamieson]

Is the database location being set up using code, for example VBA code
that is run from an Access form? If so, you will almost certainly have
to find that code and modify it. Of course, you may not be able to tell
whether this is the case or not.

Otherwise, what I would probably do is
a. open the Word document. Assuming that you see the dialog box where
it says it cannot find the data source and offers two buttons, "Find
Data Source" and "Options", click "Options", then click "Remove
data/header source. Although that will remove the data source and any
sort/filter options, all the mail merge fields etc. will still be there
in your document.
b. Once the document has opened, on the Mailings tab, click Start Mail
Merge, then make sure Normal Word Document is selected.
c. Select the merge document type you actually need.
d. reselect the data source. If you still cannot connect, there really
is a problem and perhaps we can have a look. However, if you can, then
save and close the document, and try to reopen it again to ensure that
Word still finds the data source.

Peter Jamieson

http://tips.pjmsn.me.uk

Chief Gopher wrote:
We have recently moved some files and now when I run a mailmerge that was
set-up to utilise an Access database it can't find the database.

Where do I go to be able to amend the address path ?

---
Christine

[Chief Gopher]

Is there a way to find out if there are any sort/filter elements before I
delete the link and try re-attaching it ?
--
Christine


"Peter Jamieson" wrote:

Is the database location being set up using code, for example VBA code
that is run from an Access form? If so, you will almost certainly have
to find that code and modify it. Of course, you may not be able to tell
whether this is the case or not.

Otherwise, what I would probably do is
a. open the Word document. Assuming that you see the dialog box where
it says it cannot find the data source and offers two buttons, "Find
Data Source" and "Options", click "Options", then click "Remove
data/header source. Although that will remove the data source and any
sort/filter options, all the mail merge fields etc. will still be there
in your document.
b. Once the document has opened, on the Mailings tab, click Start Mail
Merge, then make sure Normal Word Document is selected.
c. Select the merge document type you actually need.
d. reselect the data source. If you still cannot connect, there really
is a problem and perhaps we can have a look. However, if you can, then
save and close the document, and try to reopen it again to ensure that
Word still finds the data source.

Peter Jamieson

http://tips.pjmsn.me.uk

Chief Gopher wrote:
We have recently moved some files and now when I run a mailmerge that was
set-up to utilise an Access database it can't find the database.

Where do I go to be able to amend the address path ?

---
Christine

[Peter Jamieson]

Unfortunately, if you cannot re-attach the data source, then you end up
losing any information about the existing connection.

That said, if you are saving in an XML or RTF format - i.e. .docx,
..docm, Word 2007 .xml, Word 2003 .xml or maybe .rtf, you should be able
to find out the necessary details by inspecting the file (.docx/.docm
are actually ZIP files with a bunch of XML and other stuff inside them,
so you could extract the information from those - a bit of a slog
without some programming support though.


Peter Jamieson

http://tips.pjmsn.me.uk

Chief Gopher wrote:
Is there a way to find out if there are any sort/filter elements before I
delete the link and try re-attaching it ?