Need help to Fax a report

M

Mota

Hi;
I use office 2003 and 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:
SID=123
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 under a condition
or filtering.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.
 

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