SendObject problem sending reports in RTF

[azalealee]

Hi! I am using Access 97 with Lotus Notes R5 as my mail server. I have been trying to automate the attaching of reports in RTF for users through the SendObject method.

I have the following code on the onClick event for a button:

Private Sub cmdEmail_Click()

Dim WorkID As String
Dim subject As String

WorkID = Forms!F_Unsched_Work!Work_ID
subject = "Work Order number " & WorkID & " has been generated for your section!"
DoCmd.SendObject acSendReport, "R_Email_WO_Request",acFormatRTF, , , , subject, , , False
End Sub

I would like the report to open in MS Word, but for some reason, the report is attached as a .XLS with crazy unformatted data in the first cell. Weird thing is, the code works for some reports and opens them in MS Word, but doesn't for others.

Could somebody please help? Thanks in advance.

Azalea

 

[sorcerer11]

Have you explored the possibilty of using Lotus Notes ODBC client to establish the links between the two systems instead of using export functions?

 

[azalealee]

No, and I wouldn't even know where to start. Could you help me try?