SendObject Question with Lotus Notes

[salrodz]

Greetings,
I'm working with MS Access 2000 (SR-1) and using Lotus Notes 5.0.9a as my default email program. I'm having a problem using the "DoCmd.SendObject" method to generate an email with a report attached in *.rtf format. When I choose *.rtf as the output format the email is generated and the report attached, but the report format is changed to *.xls. The result is not identical to that achieved when the output format is *.xls. Further, it works fine with different formats (*.html, *.txt, and *.xls).
The code I'm using is:
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, ContactName, , "myaccount@myaddress.com", "Message Subject", "Please review the attached information.", True

Any tips would be greatly appreciated.

 

[padinka]

HMMMM, I don't see anything wrong with your code. Can you send the object manually in a RTF format?
Trisha
padinka@yahoo.com

 

[salrodz]

Good question...I tried doing that just now - sending the report manually (by right click on open report, then choosing send to) as *.rtf and the same problem occurs (gets attached as *.xls). So I guess it's not a code issue. I thought it might be a problem with my MS Office installation, but this is happening on more than one computer and I office re-installed and it didn't correct anything.

Thanks for your response.