attaching rtf report in email is converting to .xls???

[ironj32]

I have a form that has a command button that opens up lotus notes and attaches a report as an .rtf. this works on all of our pc's, but for some reason it attaches as an .xls file one persons computer. any thoughts as to why this is happening?

Private Sub cmdSendReport_Click()
Dim Subject As String
Dim Body As String

Subject = "Account Verification: #" & Me.AccountNbr
Body = "Please review the attached Verification Report and make any neccessary changes and return to Kendra"

DoCmd.SendObject acSendReport, "rptAccountVerificationQry", acFormatRTF, "", "", "", Subject, Body, False

End Sub

 

[Darrylles]

Hi,

If you have front-end MS Access application on each pc - look at the copy 'version' of the MS Access application.

Open a form - look at a module - compare Tools -> References with a correctly working pc Tools -> References.

If you have all pc's looking at a centralized MS Access application, then look at MS Access installations on each pc?

Has this EVER worked for this pc?

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.