I had a mail merge set up to work when I was in the database and clicked on a
button on a form. It opens up a word doc that is a merge all setup. It used
to not have a problem using one of the queries in my DB as the data source.
Now every time the user has to browse to the query or table and select it as
the data source. I saved the merge doc and it still does not have the data
source saved if I am opening it from my database.

Now if I close the database and just open the merge doc from windows
explorer it has no problem knowing the data source. I have to tell it that
it is OK to run the SQL, but that would be OK if it would do that from the
Access DB.

Is there some kind of fix for this?

Thanks, Pat Kung

On Jul 24, 4:00*pm, patkung <patk...@discussions.microsoft.com> wrote:
> I had a mail merge set up to work when I was in the database and clicked on a
> button on a form. *It opens up a word doc that is a merge all setup. *It used
> to not have a problem using one of the queries in my DB as the data source. *
> Now every time the user has to browse to the query or table and select itas
> the data source. *I saved the merge doc and it still does not have the data
> source saved if I am opening it from my database. *
>
> Now if I close the database and just open the merge doc from windows
> explorer it has no problem knowing the data source. *I have to tell it that
> it is OK to run the SQL, but that would be OK if it would do that from the
> Access DB. *
>
> Is there some kind of fix for this?
>
> Thanks, Pat Kung

Pat,

I know this dosen't answer your question but if you want an easy way
to do mail merge from Access check out Albert Kallal's Super easy mail
merge, you can find it here.

http://www.members.shaw.ca/AlbertKal.../msaccess.html

Hope that helps.

Rick