acSendReport with the acFormatRTF option

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi, I was wondering if anyone could help me on this one.

I created a Access 2000 form with a Command Button that
sends a RTF report to my local email client. This used to
work at one point for me but Access 2000 now creates the
RTF report with an XLS format. I notice that each time I
hit the command button it uses this sequential naming
structure of "CDB##.xls" where the ## increments by one.

The syntax I'm using is: (I tried to leave out the
formatRTF option but that doesn't work either.

DoCmd.SendObject acSendReport, "rpt_Purchase", acFormatRTF,

thanks Paul
 
Back
Top