columbo1977
Programmer
Hi All
I have the following code in my Datbase for emailing the access report.
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
I have the following code in my Datbase for emailing the access report.
Code:
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