pass query results to WORD

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have either another method for implementing Mail Merge or
something similiar? I have been scouring my books and don't find another
method.

AND The current method I am using now fails. I am using ACCESS 2K, and
users have Office 2K. Some of the users may be "upgraded" to Office 2003
soon. It is my understanding the WORD object model for 03 is different from
2K, correct????

I want to 1) allow users to create their OWN letters in WORD, then 2)
populate with data from our ACCESS app. (The data usually is identifing info
and address for a SINGLE individual along with the current administrator
information for our letterhead. Like many businesses our administration
tends to change frequently) I have been creating the RS in a click event on
my FORM, user selects the .DOT and then ACCESS mailmerges to the DOT. Using
WORD allows the users to have control over the content of the letters and
create as many as they want- (and I don't have to maintain them :) )

Thanks-
 
As RuralGuy suggested, check Albert's code.

I don't believe there were any significant changes made to the Word object
model between Word 2000 and Word 2003. What's the code you're using that's
failing (and where is it failing)?
 
GetObject failed. (I had previously posted about that, same problem). I'm
re-focusing my effort to find another (better) way than the MailMerge code I
was using instead of trying to figure out what is wrong with GetObject.

Thanks!
 
Wasn't what you asked for, but just as a suggestion, it may be easier to
write your code in MS Word VBA using Word to hook into the access db.

Cheers
Ian B
 
Loralee said:
GetObject failed. (I had previously posted about that, same problem).
I'm
re-focusing my effort to find another (better) way than the MailMerge code
I
was using instead of trying to figure out what is wrong with GetObject.
Click to expand...

The "better" way you are looking for is to use my wordmerge example. It also
uses GetObject, but have been used on every conceivpale combiaton of
operatong ytems and every copy of word MIXED with differnt versions of
ms-access, and it STILL works!!!

It uses late binding so getobject will not fail.....

So, my example has been downloaded and used by 1000's and 1000's of people
with every version from office 97 to 2003 without a hitch....

My code example is DESIGNED from the ground up to merge the current record
you are looking at, and also has provisions for specifying a query to use.
It is fast, simple, and most merges you write for a form take 1, or two
lines of code (yes, I am not kidding..1, or 2 lines of code..that is it
!!!!).

You can find it here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
 
Thanks, that's cool.

I've only had a chance to do a quick once-over, and didn't see any specific
guidance as far as express permission to use within an app. As long as I
leave everything intact (comments, etc.) can I assume it's okay to use? We
are using it for an app we use internally in a local public health program
for a nursing project- not for resale or any such business.
 
Back
Top