Changing db Mail Merge is Linked To

[Guest]

A couple years ago I created a mail merged document linked to an Access db I
have. Since then, I changed the name of the database. The mail merge, upon
opening prompts me to locate the database. I point to the newly-named
database and all works fine.

I am trying to find the setting which will allow me to remember the change
of databases and cannot find where that is. Will someone kindly point to
where I can save the document with the new link to the database?

Thank you.

 

[Guest]

There is no need to 'redesign the document' or anything else if your original
message is accurate.

(You can also *disregard* the second para of my first reply... as stated
therein, that shouldn't be happening anyway. That was prompted only by your
reference to the "merged file".)

When you are 'prompted for another source' just follow the prompts to
specify _what_ the new source should be (you already said that it works fine
when you do)... but _do not_ complete the merge yet.

As soon as you specify the new source, *Save the File* as you would normally
save changes to any other file. From then on it will 'remember' the new
database name instead of the old one.

If the info you provided in your original posting is correct about simply
having changed the name of the Access file, nothing more should be necessary.

Regards |:>)