In this Microsoft Access tutorial, I will show you how to export a customer report to a Microsoft Word document using a Report, the OutputTo command, and two lines of VBA code.
Tricia from Flint, Michigan (a Platinum Member) asks: Is there any way I can export the information in a customer's file to a Word document? I know you can create reports in Access, but my boss wants us to save each customer's info in a Word doc that can be easily edited and emailed without having to use the database, but I also want to keep all of the rich text formatting I have in my database. Additionally, if there's a way to put the customer's picture in the Word document, that would be awesome.
Silver Members and up get access to an Extended Cut of this video. Members will learn how to dynamically create a Word document using VBA. This will allow us to take direct control of each object that goes into the document, formatting (including the formatted rich text from Access), and we can insert pictures and change their attributes.
MEMBERS VIDEO:
• Export Report from Acc...
BECOME A MEMBER:
KZfaq: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/ExportToWord
LINKS:
VBA: 599cd.com/VBA
Open Report Specific: 599cd.com/OpenReportSpecific
Rich Text: 599cd.com/RichText
Letter Writer: 599cd.com/LetterWriter
SUGGESTED COURSE:
Access Expert 19: 599cd.com/ACX19
GOLD MEMBER CODE VAULT LINKS:
VBA Source Code: 599cd.com/CreateWordDoc
OTHER COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, export to word, rich text, rtf, outputto, acformatrtf, acformattxt, acformatpdf, How to Export Access Data to a Word Document, export images, How To Convert Access Report To Word Document, MS Access export report to Word with formatting, Export report to MS Word with formatting intact, me.refresh, acOutputReport, microsoft word 16.0 object library, typetext, inlineshapes.addpicture, activedocument
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.