How to Fax a Report through code?

M

Mota

Hi;
I have a report that has a groupping factor named SID.So i always have to
open it with a special SID using an expression like this:
DoCmd.OpenReport "StatementRPT",,,"SID=" & SID
Now i want to fax it and i dont know what to do.Because the SendObject
Method of DoCmd has no argument to Open a form or report.I use this command
to Fax this report:
MyFaxNo="0001234567"
DoCmd.SendObject acSendReport, "StatementRPT", acFormatSNP, "[Fax:" &
MyFaxNo & "]"
In this case all the report opens in fax printer,regardless of the SID i
want.Is there any solution ?
This is my most important problem,but i have 2 more questions :
1-what is the best format constant to use when faxing a report?I used
acFormatSNP but im not sure is the best.
2-I use both WinFax and Microsoft Fax (Win XP Fax software).Is there a way
to send a report directly to one of these faxes ,without using Microsoft
Outlook?Is it possible?

I appreciate your help and thank you in advance for your reply.
 
J

Jeff C

Do a thorough search in the OUTLOOK forums and OUTLOOK programming areas. I
have seen your solution described using outlook to send faxes. Using your
sendobject gets the report to e-mail and there are ways evidently to get your
e-mail to a fax.
 

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

Top