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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error emailing Excel attachment 2
multiple attachments 3
acFormatXLS Works in 2003 not 2007 1
DoCmd.SendObject acSendReport 1
Sending multiple reports, attachments 1
Send Email 2
docmd.sendobject 1
Need Help to Convert report file in Access to PDF using VBA 3

Back
Top