MS Access 2003 and Word 2003 Mail Merge Problem

[pmhaupt2]

I developed an Access 2003 program that will allow the user to produce
a group of Word letters that merge with data records from an Access
database.

I created a mail merge Word document and associated it with a specific
query in my Access database.

My problem is that when I run my "create letters" button from an Access
form, the program opens up Word correctly with the proper letter.
However, the MailMerge toolbar in Word appears greyed out (inactive)
and I only see the first letter with the merged data from the first
record of the query. I cannot turn the MailMerge toolbar on nor can I
view any additional letters.

I then tried my program on two other employees' PCs and the mail merge
process worked perfectly (i.e. the MailMerge toolbar was active and I
could view each individual letter). Both of these employees are using
MS Professional OS and MS Office 2003, just like me. I also tried
opening the mail merge Word document directly from Word and the merge
process worked fine (i.e. MailMerge toolbar was active and I could view
all the letters with the merged data).

Is there some setting in Access or Word that might cause the MailMerge
toolbar to "go inactive" on my PC, yet work fine on another PC?

Any help would be greatly appreciated.

Thanks...Peter

[Dixie]

Peter, how does your document know where to get the data. Code in the
access database, or built into the letter?

dixie

<pm******@cox.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

I developed an Access 2003 program that will allow the user to produce
a group of Word letters that merge with data records from an Access
database.

I created a mail merge Word document and associated it with a specific
query in my Access database.

My problem is that when I run my "create letters" button from an Access
form, the program opens up Word correctly with the proper letter.
However, the MailMerge toolbar in Word appears greyed out (inactive)
and I only see the first letter with the merged data from the first
record of the query. I cannot turn the MailMerge toolbar on nor can I
view any additional letters.

I then tried my program on two other employees' PCs and the mail merge
process worked perfectly (i.e. the MailMerge toolbar was active and I
could view each individual letter). Both of these employees are using
MS Professional OS and MS Office 2003, just like me. I also tried
opening the mail merge Word document directly from Word and the merge
process worked fine (i.e. MailMerge toolbar was active and I could view
all the letters with the merged data).

Is there some setting in Access or Word that might cause the MailMerge
toolbar to "go inactive" on my PC, yet work fine on another PC?

Any help would be greatly appreciated.

Thanks...Peter

[Albert D. Kallal]

Grab my solution.

It allows to word merge any ms-access form (it even lets you merge just the
ONE record you are looking at).

Even better is it manages the creation of templates for you.

Give the sample a try...you can find it here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

On Mon, 04 Jul 2005 17:35:26 GMT, "Albert D. Kallal" <ka****@msn.com>
wrote:

Grab my solution.

It allows to word merge any ms-access form (it even lets you merge just the
ONE record you are looking at).

Even better is it manages the creation of templates for you.

Give the sample a try...you can find it here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

Albert,

Nicely done, thanks!

LB

[Peter]

Dixie,

I opened the Word document, selected the "Open Data Source" from the
MailMerge toolbar, and selected the appropriate query, Then I just
added the necessary fields.

I am going to try Albert's mail merge code provided.