Export a Query to a Word Document with a Button - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Export a Query to a Word Document with a Button

Roger Simms

13 months ago

one that uses VBA to export a query to word document/Template with a button. I know how to do this using the menus but need to incorporate it in a form. So the button needs to run the query, export the results to a word template/document and would need to know the path to the template.There is an extended cut but its based on a report for a single record.
Thanks

	Thomas Gonder @Reply 13 months ago
Tell us the title of the extended cut, and maybe we can start there?

	Richard Rost @Reply 13 months ago
Have you tried this? Export to Word

Roger Simms OP @Reply

13 months ago

Thanks Guys I didnt really take a good look at Lesson titled "Export to Word" as it was a report and not a query. After Thomas asked what the title was I decided to take a closer look and realised that a report allows you to have more control where the columns in the report will be spaced. I then looked at the extended "Export a Report from Access to Word" but I wanted to export to a template to show the Logo image but it did not show that and all my experimenting didnt Help. I then realised there was also an extended version for that title where it explained there was a work around that would allow a picture in the report to sent to a PDF file and then opened in Word that allowed editing. I just needed a jump start so Thanks again

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View