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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.