J
jmauslby
I have created a report in Access that has various fill/background colors per
column. I have created a macro using SendObject to export the report via
email in an Excel 97-2000 format. When you go to the email and open the .xls
attachement the only color that is still left is the color red. If you just
go into the report directly from the reports tab in Access and export to the
same version of .xls and then go view the spreadsheet all of the colors
remain in tact. I didn't know if there was some setting that I had not set.
The other thing I thought it might be, is the colors I was using were not the
same as .xls, but they appear to be. The only thing I haven't checked is to
see what the numeric value for the color is in .xls, but I don't know where
to look in .xls. Thank you in advance for your assistance!!!!!!
column. I have created a macro using SendObject to export the report via
email in an Excel 97-2000 format. When you go to the email and open the .xls
attachement the only color that is still left is the color red. If you just
go into the report directly from the reports tab in Access and export to the
same version of .xls and then go view the spreadsheet all of the colors
remain in tact. I didn't know if there was some setting that I had not set.
The other thing I thought it might be, is the colors I was using were not the
same as .xls, but they appear to be. The only thing I haven't checked is to
see what the numeric value for the color is in .xls, but I don't know where
to look in .xls. Thank you in advance for your assistance!!!!!!