acSendReport with the acFormatRTF option

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
 
C

Charlie Wilson

Did you find a solution to this problem? I have a very
simlar problem?
Charlie
 

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

SendObject Attachment file name 1
acFormatRTF creates a Word Document with missing text??? 1
acSendReport Problem 0
No option to create a list in SharePoint Site 0
acFormatRTF creates Excel file 0
Loosing lines from rpt file when using acOutputReport with acForma 1
report not align 0
Emailing a report in Excel format 0

Top