Has anyone ever exported data into MS Word from Access? I have a table that consists of emails that were imported from Outlook. I now want to be able to export this into Word so that i can print them out. I got it to export using the Export option under File and chose the file type of Rich Text Format - this throws it into Word. The problem i'm having is that i want to put a page break in between each record, but am not really sure on how to do this. Any thoughts?
-
-
A quick and dirty solution - not necessarily the most elegant, but it works
1. Create a tabular report in Access from your query (use the wizard)
2. Open the report in Design View and insert a page break at the end of the detail section.
3. Save the report and check in Print Preview that you are getting the desired result
4. Export the Report to Word.
(In Access 2000 you do this from Tools>Office Links>Piblish it with MSWord. May be somewheer else in other versions)
Comment