By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Exporting Data

P: 111
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?
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply

P: 47
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)
Sep 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.