Exporting Access Report with formatting

[columbo1977]

Hi All

I have the following code in my Datbase for emailing the access report.

DoCmd.OpenReport stDocName, acPreview
    DoCmd.SendObject acSendReport, , acFormatRTF, _
    "graham.millichap@northyorks.gov.uk", , , _
    "Test Email", "test", False, False

If I export to RTF the report looks just as it does in Access which is what I want but my users would prefer the infromation in Excel as they can then fill in the blanks. Problem is when I export into excel I lose the look and feel of it and when opened in Excel the Title from the top of the report is gone, any ideas how I can get it to stay?

Thanks

Graham

 

[jrbarnett]

By "Export to Excel" do you mean using acFormatXLS instead of acFormatRTF?

John

 

[columbo1977]

If I use acFormatXLS then I lose the title and it just looks liek a notmal datasheet. I want to use XLS but keep the formatting like when you use RTF

Gra

 

[jrbarnett]

Could you not have the data entry in Access to fill in the blanks, then output the completed report using either Access Snapshot or PDF (using the Access 2007 Save as PDF or XPS addon). Both will produce perfect non editable reports which you can have complex formatting on.

John