Expert: Rob Henderson - 2/15/2005

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