Send object fails

  • Thread starter Thread starter Ayala
  • Start date Start date
A

Ayala

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

Private Sub cmdRequestBC_Click()
DoCmd.SendObject acSendReport, "rptBusinessCard",
acFormatRTF, "(e-mail address removed)", , , "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?
 
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.
 
Back
Top