RE: Albert Kallal's Mail Merge

Great, that works! Thanks

"Wayne-I-M" wrote:

I think Albert will answer you but in case he is away I have looked at his
code and I "think (?).....

You should place folders with the word docs on the server - if you have
split the DB place the folder(s) in the same place as the back end

If you create a word doc folders (with word docs in) place the merge888 in
each folder.

The reason for createing multiple folders is that you can specifiy the
direction of the path from the word merg OnClick

So
If you have people buying fruit
You can have a folder called Apples and another called Pears. The Merg888
goes into each folder.

The on click of your word merg button may look like this

Dim strSql As String
strSql = "select * from QueryName where ID = " & Me!ID
MergeAllWord strSql, "Name of word doc folder here"

So you can set up a query to "feed" the merg so that you don't have a "very"
large list of Doc's - you only have the relevant Doc's for that
client/customer

HTH

--
Wayne
Manchester, England.



"TheCaptain" wrote:

Hello,

I am putting my database (Access 2007) onto a network. The end users are
using Access RunTime. If the end user runs the Mail Merge he ends up with
error:
"test.doc is a mail merge main document. Word cannot find its data source,
C:\DOCUME~1\Freddy\...\Template\merge.888"

On Albert's website he says that if there are multiple users you must split
the mdb. How to you split it?

Thanks
.