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?
Any idea why the SendObject is sending an .xls instead of an .rtf when its coded to send .rtf?