Mail merge to word

[Paul]

hi,

I'm using access/word 2003;

I recently secured my database with the access security;

I've got several Word documents retrieving data from the database using mail
merge; after applying the security this is no longer possible.

Offcourse i tried to reset the source to the secured database, but it cannot
open the database because of password conflicts (I'm a 100% sure I'm using
the correct administrator password). Do I connect to the .mdb or .mdw? or
both? If so, how?

Any ideas?

Cheers,

Paul

 

[Albert D. Kallal]

hi,

I'm using access/word 2003;

Offcourse i tried to reset the source to the secured database, but it
cannot
open the database because of password conflicts (I'm a 100% sure I'm using
the correct administrator password). Do I connect to the .mdb or .mdw? or
both? If so, how?

Securty can be a bit messy with word merge.

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

This sample also eliminates the issue of security and secured access
databases will work find with word and my merge code...

 

[Paul]

Albert,

Thanks for your reply! It looks fantastic, I'm currently out of the office
so I'll try it on my application on monday!
Let you know!

Cheers,

Paul

 

[Paul]

Albert,

I tried it on my application, it works like a charme!! Thanks again!!!

Cheers,

Paul