Albert Kallal's Mail Merge

[TheCaptain]

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

 

[Wayne-I-M]

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

 

[TheCaptain]

Great, that works! Thanks

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-I-M]

I have just had a play around with Alberts mail merge (it really brilliant)

Just one thing you want to add - I would dim the mail merge folder into the
onclick - so you will need to have some method of showing this on your form
or in the base query you could could use a simple iif=pears then
"foldername=" or iif=apples then "foldername=". Of course Albert may have
this already but could not find it.

Doing this will mean you can have hundreds of word.docs but only show the
applicable docs on the list (it a very basic doc filter) on each form

HTH