Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Merge data with Word document within Access - How!

I have a query created that writes data to a temporary table.  The table will only have one record ever.  But them somehow within Access I would like to merge that data with a Word template document and print that Word document via a command button on a form.

So basically here are the steps.

1) User clicks a command button on a form.
2) The onclick event of the command button deletes previous data and creates the new table data (I have this working already)
3) The data is merged with the Word document which will reside in the same directory as the front-end file of the Access database.
4) The Word document will print.

And with steps 2-4 happening without the user having to do anything.  Is this possible?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SteveL13

ASKER

To all:  I'll be working on this more tomorrow.