Send object fails

A

Ayala

Hi, this is my code for a command button in a form

Private Sub cmdRequestBC_Click()
DoCmd.SendObject acSendReport, "rptBusinessCard",
acFormatRTF, "[email protected]", , , "Business Card", ,
False
End Sub

The problem is that I can't send it in RTF format, it
always sends it as XLS format and the data in the report
is corrupted.
If I choose other format it works ok, but I need RTF
format.
Any ideas why is this happening?
 
K

Kevin11

Maybe your Access is fine. It looks like your Windows
settings are trying to open RTF files in Excel instead of
Word. If this is the case change your Windows settings so
that your RTF files open in Word instead of Excel.

Just an idea. Good luck.
 
Top