By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

MS Access 2003 and Word 2003 Mail Merge Problem

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.