pass query results to WORD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loralee - 26 Nov 2006 16:31 GMT

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-
--
Loralee

Reply to this Message

ruralguy - 26 Nov 2006 16:48 GMT

Have you looked at Albert D. Kallal's "Super Easy Word Merge"?
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

>Does anyone have either another method for implementing Mail Merge or
>something similiar? I have been scouring my books and don't find another
[quoted text clipped - 15 lines]
>
>Thanks-

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Douglas J. Steele - 26 Nov 2006 16:52 GMT

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)?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Does anyone have either another method for implementing Mail Merge or
> something similiar? I have been scouring my books and don't find another
[quoted text clipped - 19 lines]
>
> Thanks-

Reply to this Message

Loralee - 26 Nov 2006 20:04 GMT

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!

Signature

Loralee

> As RuralGuy suggested, check Albert's code.
>
[quoted text clipped - 25 lines]
> >
> > Thanks-

Reply to this Message

Ian B - 27 Nov 2006 02:58 GMT

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

> 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
[quoted text clipped - 29 lines]
> > > 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-

Reply to this Message

Albert D. Kallal - 27 Nov 2006 15:08 GMT

> 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.

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

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Loralee - 29 Nov 2006 04:53 GMT

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.

Signature

Loralee

> > GetObject failed. (I had previously posted about that, same problem).
> > I'm
[quoted text clipped - 21 lines]
>
> http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Reply to this Message

Albert D. Kallal - 02 Dec 2006 22:27 GMT

all yours to use.....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message