Word mail merge functions are disabled when called from Access 2003

  • Thread starter Thread starter Steve P
  • Start date Start date
S

Steve P

I have an Access 2000 application that programmatically opens a Word
document and populates it with data from one of the tables in Access. I just
converted the applications(Word and Access) to 2003. Now the Word documents
work fine if I open them from Word. However, when they are launched from
within Access the mail merge feature is disabled. So the document opens with
the first record of Access data embedded in it but the mail merge record
selectors are grayed out. Any suggestions on why the mail merge feature is
disabled when called from Access but not when the document is opened
directly from Word would be greatly appreciated.

Thanks,
Steve P.
 
I believe this has to do with new security settings.

however, you can give my example merge code a try...it does work with
a2003..and it might very well be a substitute for you.

You can give it a try here:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

If my memory serves me correct, simply setting the merge source of the word
document via code fixed this problem.
 
Steve P said:
I have an Access 2000 application that programmatically opens a Word
document and populates it with data from one of the tables in Access. I just
converted the applications(Word and Access) to 2003. Now the Word documents
work fine if I open them from Word. However, when they are launched from
within Access the mail merge feature is disabled. So the document opens with
the first record of Access data embedded in it but the mail merge record
selectors are grayed out. Any suggestions on why the mail merge feature is
disabled when called from Access but not when the document is opened
directly from Word would be greatly appreciated.

Thanks,
Steve P.



Hi Steve,
Click to expand...
I have the same problem with an Access 97 app that the client wanted
converted to Access 2003. Did you ever get a solution? I tried the link in
the response that you got, but it bombed. I've thought of opening Word and
creating the documents on the fly through VBA code from Access, or even
opening Word from Access and using an Autoexec to create the documents from
within Word. Just thoughts that need to be explored, unless there is a "fix"
for this anomaly.

Thanks in advance,
Joeb
 
Back
Top