Mail-merge without leaving Access

R

Ricoy-Chicago

My boss wants to print a "contract", this contract is in MS word but the data
fields needed are in Access. No problem here. The problem is that he wants to
print 3 copies of the same contract from the [Print] form in Access.

I have this partial solution: create a command button in the [Print] form in
the Access front-end and have a for-next loop that will run three times. My
problem is:

How do I code it so MS word opens and prints the "contract.doc" file? I know
that this file will be the form file of the mail-merge process.

Thank you for your help.
 
A

Albert D.Kallal

Well, I would just do the merge to word, and then when they hit print, they
select 3 copies...

(after all, sometimes they might only want one copy).

I have a nice sample word merge here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Grab the above, and try it. There is also instructions on the web site to
USE THIS code in your application. Read them...

I think you will find the above a pleasant solution.
 
Top