Page Set up is messing up from Access to Word using office links>Publish to word

I have my report all nice and formatted in Access. I have kept pretty tight margins to decrease the number of pages that prints in Word. I use the tool bar  Tools>Office Links> Publish to Word and the report publishes to word and the bottom margin changes from about .25 inches to 3.0 inches, adding tons of space at the bottom.

When I print directly out of Access, the margins are just fine. Trouble is I need to publish to Word, so I can post to our exchange server as a Word Document.

I did not know if there was a page set up command or preserve formatting field/property that I am missing?

Our work still uses Office 2003.

Thanks for any tips.
bvanscoy678Asked:
Who is Participating?
 
Helen FeddemaCommented:
RTF export generally doesn't work very well.  I recommend creating a properly formatted Word template, then using Automation code to fill a document created from the template with data from Access.  That gives you total control over the appearance of the Word document.  See my Code Sample #24 (Four Ways to Merge to Word) for more information.  It is rather old, but still works.  For more updated info (including Word 2007 and 2010), see my recent ebook, Working with Word.

Here is the link for the code sample:

http://www.helenfeddema.com/Files/code24.zip

For another example of exporting Access data to a Word document, see my Access Archon #44 (Merging to Word from Linked Access Tables):

http://www.helenfeddema.com/Files/accarch44.zip
0
 
bvanscoy678Author Commented:
Thank you very much for the links. I just printed them and will read for the examples. I only have a couple of reports I deal with like this, so it is something I have just dealt with. But, it will be nice to possible fix them!

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.