Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SendObject sending as .xls in error.

Status
Not open for further replies.

bkf7911

MIS
Mar 20, 2007
83
US
I'm using the SendObject method in a macro to send a Report from MS Access to LotusNotes as a Rich Text File. On my PC it works fine. On another user's PC, it HAS worked fine, but today it started sending the file as an Excel file instead of Rich Text. Nothing has changed about this database in weeks, and the other User confirms no changes to his PC. Another weird thing, is that another macro, containing similar macro-steps sends the file as .rtf with no issue.

Any idea why the SendObject is sending an .xls instead of an .rtf when its coded to send .rtf?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top