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.
How do i change the page setup default on a document imported from access to word?
Collapse
X
-
Anita YourhelpTags: None -
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