Application Title interferes with Word Mailmerge 1

[8441]

I have an Access 2000 database which has several word documents connected to with with mail merge.

It all works fine with the letters created in Word and mail merged run from a button on a form. Access passes over the reference number to Word which identifies the required data. As soon as I add an application title via the Startup dialog in Tools/Startup the Word Letter asks for the reference number when it is opened. Nothing else has changed except for the application title.

Any ideas? Thanks

Craig

 

[JeremyNYC]

Craig,

Yeah, this is a big PITA. I had to write code to change the app title, deal with word, and then change the app title back.

My PC is freaking out a bit right now so I can't grab the code, but let me know if you want it. I don't think it's so complex, though.

On a side note, at some point I also ran into a problem where I could interact with word in the way I wanted to unless I renamed my .mde to .mdb. Didn't actually care about the file format, just the file name.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[lcoble]

Craig,

I ran into the same problem using a Run-time version of Access. I found the code to change the title then change it back at this site.

http://www.mvps.org/access/bugs/bugs0011.htm

Bugs: Mailmerge starts new instance of Access -- Posted by Dev Ashish---

 

[JeremyNYC]

Yeah, I'm pretty sure that's where I learned how to deal with this. Great site, great guys who maintain it and keep it full of helpful stuff. =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[8441]

Thanks to both of you. I will have a look at the site.

Craig