Mail merge link being lost

[Guest]

Hi.

I have a number of command buttons each of which uses a Hyperlink address
to open a mail merge document. This works fine most of the time but
occasionally, for no apparent reason, the Word document opens OK but without
the link set to the mdb's query. I have given the users instructions on how
to 'repair' the link but it is frustrating for them.

Any idea why the Word document is losing its link to the mdb and any
suggestions for a more robust way of setting this link? I.e. is there some
way to sort of 'hard wire' the Word documents to the data source in code that
sits in the Word document? Perhaps this is a question for the Word discussion
group but I'll wait for a reply here first.

I'm using Access 2000, XP and a really flaky network.

Cheers, JohnB

 

[Albert D. Kallal]

I had a number of problems in this area. As a result, I now always re-set
the data source of the merge EACH time in my code.

I have sample download for word merge that has been rather battled hardened
by MANY MANY users in these forms that download the program. When we find a
problem, it is fixed. One of them was inadvertently changing the data source
of a word merge document. With my sample, users never have to set this, and
if they change the data source, then my code changes it back!!!

The word merge has not reached a point where it is quite reliable. In
addition, my word merge works on secured databases, and even those with a
password. All of the security stuff is by-passed with my example code.

You can give my sample a try here:

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

If you like the above, then follow the instructions on the web site on how
to use this in your existing applications...

 

[Guest]

Thanks Albert.

I'll take some time to look over your sample mdbs but one thing I noticed in
your intro, where you said:

"......merging a single record in ms-access to a word document."

In my case the source recordset is a query which concatenates certain fields
from a one-to-many relationship. In this way, the mail merge document takes
the form of a set of letters to schools where each letter shows a school name
(the 'one' side)at the top and down below a number of student names (the
'many' side). Will your solution work with this?

Thanks again, JohnB

 

[Albert D. Kallal]

In my case the source recordset is a query which concatenates certain

fields
from a one-to-many relationship. In this way, the mail merge document
takes
the form of a set of letters to schools where each letter shows a school
name
(the 'one' side)at the top and down below a number of student names (the
'many' side). Will your solution work with this?

Yes, if your word merge now is based on a query, then I don't see any reason
why my sample
would not work.

So, if the above means can you send a query of your choice in my merge
system? yes, you can.

The sample has a "merge all records" example (try the button on the sample,
and then view the
code - it is only 2 lines of code). So, you can well use a query (or sql) in
place of the forms
reocrdset.

In addition to the sample download, there is additional syntax examples
here:

http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html

 

[Guest]

Thanks Albert.

I'll give this a good look over.

Cheers, JohnB