Send Object in Access

[commandchief]

When I am sending a query object in an e-mail in Excel format, the data resulting Excel file appears to be in reverse video. I have to open each file and change the font color so it's readable. I'm not sure when this happened but it only affected the queries I created during a certain time period. Now all the queries I'm exporting are working correctly. I have not been able to go back and recreate the queries and make them work.

 

[HarleyQuinn]

I'm not sure I understand what you want us to help you with?

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[commandchief]

I don't know any other way to explain it because I don't know why it's happening. I have a database that emails a series of spreadsheets. Some of those spreadsheets have the data in reverse video and some don't. It's not happening now with the new queries I create for the sendobject but recreating those that are screwed up doesn't seem to make any difference. It's almost like they are tied to an Excel template somewhere but I have searched my hard drive and the network drives and can't find anything.