Send To changes format in Access2000??

[Johnny Gee]

Hi All

I have a macro that I use to send three reports every week to about 10
people by email via Lotus Notes.I use the "Send To" command to send the
reports out in Rich Text Format. I used RTF because it was the most
compatible way for everybody to open the report. For reasons unknown to me,
one of the reports changed "itself" to .xls format. I have tried sending the
report seperately but although I select Rich Text Format it still attaches
to the email as .xls and then it is just garbage.The other two reports are
still ok.

The only way I can get the report to revert back to using RTF is to delete
it and design it again as a new report.It has done this 3 times now in the
last 4 months and I can find no explanation why. It only happens to the one
report not the other two. The three reports are all from the same table and
basically just list "work completed", "work outstanding" and "work in
progress" for the end of each week. I have tried reinstalling Access etc but
it makes no difference.

Has anybody seen this happen before or am I just being haunted or something?

Thanks in advance for any advice.

Johnny Gee

[Tom van Stiphout]

On Mon, 13 Sep 2004 18:38:57 +0000 (UTC), "Johnny Gee"
<jp**************@btinternet.com> wrote:

Fortunately you keep good backups so you don't even have to recreate
the report.

Corruption is a whimsical thing.

-Tom.

Hi All

I have a macro that I use to send three reports every week to about 10
people by email via Lotus Notes.I use the "Send To" command to send the
reports out in Rich Text Format. I used RTF because it was the most
compatible way for everybody to open the report. For reasons unknown to me,
one of the reports changed "itself" to .xls format. I have tried sending the
report seperately but although I select Rich Text Format it still attaches
to the email as .xls and then it is just garbage.The other two reports are
still ok.

The only way I can get the report to revert back to using RTF is to delete
it and design it again as a new report.It has done this 3 times now in the
last 4 months and I can find no explanation why. It only happens to the one
report not the other two. The three reports are all from the same table and
basically just list "work completed", "work outstanding" and "work in
progress" for the end of each week. I have tried reinstalling Access etc but
it makes no difference.

Has anybody seen this happen before or am I just being haunted or something?

Thanks in advance for any advice.

Johnny Gee