Mail Merge from .MDE

  • Thread starter Thread starter Ian Smith
  • Start date Start date
I

Ian Smith

I am trigering a word mailmerge from an Access97
application. The application displays a dialog form that
collects parameters for the quary that word will merge
from.

I carefully set my application name to "Microsoft Access"
before initiating the merge, and from an .mdb copy of the
application, it all behaves.

From a .mde copy of the application, however, Word insists
on opening another copy of Access and mayhem ensues.

Can a mailmerge be made to work against a .mde file?
 
Dammit--It didn't work.

The knowledge base article looked promising, but after
renaming my .mde file to .mdb, word still opens another
copy of access. And yet with my "real" MDB file, it works
like a charm.

It is appalling how badly Word and Access play together.
 
Unbelievable! I guess this one of those myriad of things which fell
into the "We'd rather add new features than fix old bad stuff"
category between 97 and 2k. Do you know if this still happens in XP?
 
Yes...it does. In fact, there are even more problems, i.e., currency values
are merged as standard numbers. This isn't the case in prior versions of
Access/Word. Also, they have the stupid word mail merge "wizard" start,
even though you have already set the mail merge source for the document.
And then you have to add the Insert Merge Field to the mail merge toolbar
(it isn't there by default). They really screwed up mail merge in XP.
Which reminds me, I need to see if they fixed any of this in 2003 version.
 
UN-(unprintable)-beLIEVABLE! Guess I'll keep doing mailmerge from
csv files.

Remember WordStar? Or the last Word that really worked, 6.0 for DOS?
 
A neat method I've read exports the merge data
to a hard disc RTF file and sets up the merge
between the Word document and the RTF file.

See "Access Cookbook" by Getz, Litwin and
Baron, or post again if you want further details.

Regards
Geoff
 
Thanks Albert.

Your basic approach... Exporting to a .csv file and
merging from that was my "Plan-B". I am glad to hear that
works reliably for you.
 
Back
Top