How do i change the page setup default on a document imported from access to word?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Anita Yourhelp

    How do i change the page setup default on a document imported from access to word?

    I'm trying to export an MS Access 2000 report to an .rtf file. In Access, default settings show page setup as letter sized. In word, my default settings show letter sized. However, when i export the document, it changes the page setup to a custom size of 17"x22". There are tons of reports so I don't want to have to change the print setup on each one before sending them out.
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Firstly an rtf will not hold any formatting.

    You could try using office automation to change the page size after it's been saved as an rtf.

    Without knowing a lot more about your setup all I can give you is the basic code.
    Code:
    Documents("YourDocument").PageSetup.PaperSize = wdPaperLetter

    Comment

    Working...