Using MS Access/Link Access to Word

Advertisement


Question
Not a beginner, but not my normal field of expertise.  I have an Access database that I have been doing reports and then printing to AdobePDF to electronically transmit.  I must transmit the reports in either Word or Excel without using Adobe PDF and need to do it automatically with a command button either on the form or report in Access.  I have the form duplicated in Word and have tried to use mail merge, but haven't had great success automating the function inside Access.  

Answer
SHi

So you want to print out a report to Word?

If so have you considered using the Publish functionality on the toolbar? You can easily recreate this by using a macro or even better using VBA and then attach to a command button.

If you are attempting to do a mail merge it's a different approach.

rob

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Rob Henderson

Expertise

I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions. I also have expierence in application design for all the Office components (Excel, Outlook, etc).

©2012 About.com, a part of The New York Times Company. All rights reserved.