By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Send To changes format in Access2000??

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.