T
Tatakau
I am automating a mail merge from a split & secure Microsoft Access 2000
database. When a button on one of my forms is clicked, the following code is
run:
on error resume next
set objword = getobject(datapath() & "letters/confirmation letter.doc",
"word.document"
objword.application.visible = true
objword.mailmerge.opendatasource name:=currentdb.name, linktosource:=true,
connection:="Query confirmation", sqlstatement:=""
This code will send a query to a word document and use the query results as
record entries for the mail merge. It works fine from my MDB file. However,
when I turn the MDB into an MDE for distribution, the word document does not
recognize the data - it only sees gibberish.
When the mde opens Word, the letter opens and a "Header Record Delimiters"
dialogue pops up, asking for a feild and record delimiter, obviously
attempting to open the MDE as a text file.
I think that Word doesn't recognize the security that is in place for the
MDE file, and that somehow I need to give it a username and password. Is
there any way to do this?
Thanks,
Nick
database. When a button on one of my forms is clicked, the following code is
run:
on error resume next
set objword = getobject(datapath() & "letters/confirmation letter.doc",
"word.document"
objword.application.visible = true
objword.mailmerge.opendatasource name:=currentdb.name, linktosource:=true,
connection:="Query confirmation", sqlstatement:=""
This code will send a query to a word document and use the query results as
record entries for the mail merge. It works fine from my MDB file. However,
when I turn the MDB into an MDE for distribution, the word document does not
recognize the data - it only sees gibberish.
When the mde opens Word, the letter opens and a "Header Record Delimiters"
dialogue pops up, asking for a feild and record delimiter, obviously
attempting to open the MDE as a text file.
I think that Word doesn't recognize the security that is in place for the
MDE file, and that somehow I need to give it a username and password. Is
there any way to do this?
Thanks,
Nick