About 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).
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.
