Send changing from RTF to XLS going into Lotus Notes

[Guest]

Trying to Send a report as RTF to Lotus Notes. It is being sent as an XLS. Name also is changed to a hashed name like CDBIA.xls. When viewed in Excel, it looks messed up. Only happening to one report. Other reports in the same database work correctly. Someone else opens the same report, from the same database, and can send an RTF file. Access 2000 SR1, Lotus Notes 5.0.11
Thanks for any suggestions!!!

 

[Frederick Launoy]

I'm having exact the same problem but when I trie to send in snapshot
format. I have been searching for hours to find the solution and I have
found a lot of people on the net with the same problem, but no one seems to
know the answer... I'm getting pretty desperate ...
Please let me know if you find the answer.
Can't anyone from Microsoft answer on this subject ?

Trying to Send a report as RTF to Lotus Notes. It is being sent as an XLS.

Name also is changed to a hashed name like CDBIA.xls. When viewed in Excel,
it looks messed up. Only happening to one report. Other reports in the same
database work correctly. Someone else opens the same report, from the same
database, and can send an RTF file. Access 2000 SR1, Lotus Notes 5.0.11

 

[SA]

Fred:

1.) Are you using Lotus Notes?
2.) Are you specifying the format using the Access constant or the full file
type name (e.g. Snapshot Format (*.snp))?

 

[Frederick Launoy]

I use the full filename, but the strange thing is that on certain machines
it works an on others it doesn't, even on some machines it worked for a
ceratin time and than all at once the filename and extension changed without
touching the code ...

 

[Frederick Launoy]

And I use lotus notus, sorry, forgot that one, and when I change the mail
client to outlook express it works fine

 

[SA]

Fred:

Right. As I noted in another post just yesterday, this problem has been
noted before, primarily with Lotus Notes nail clients.

Have you compared the entries in the Note.ini and formats.ini files under
the Lotus\Notes directory between machines where its working and machines
were it is not?

If you find anything there, please post back to the ng's as it will be
useful and searchable by others.

(BTW you might try sending the mail item using our PDF and Mail Library for
Access, which supports Notes, and see if that helps.)

 

[Frederick Launoy]

What should I be looking for in those ini files ?

 

[SA]

Fred:

Really I have no idea; they simply contain a lot of format information for
various file types when rendered in Notes. I thought by reviewing them you
might find some inconsistancy between workstations where files display
properly and those that don't.