• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

Options for faxing from MS Access 2010

I've searched EE and there are lots of answers about faxing, but they all seem to be several years old and most of them aren't clear about the minimum requirements, so I'm opening a new question.

I'm looking for a relatively easy and inexpensive way to fax MS Access reports from within Access/VBA through a local fax modem.

The machines will not have MS Exchange installed but do have current version of Outlook.

Client rejected internet service based solution, such as Interfax.

I tried FaxMan but had incompatibilities on the computer and their tech support was not able to resolve them.

So, I'm looking for a different ActiveX recommendation or guidance on how to fax using using Faxcomex without MS Exchange.
0
Kaprice
Asked:
Kaprice
  • 10
  • 3
  • 2
  • +1
5 Solutions
 
Jeffrey CoachmanCommented:
<I've searched EE and there are lots of answers about faxing, but they all seem to be several years old and most of them aren't clear about the minimum requirements,>

...Because "Email" is now a far superior method for transmitting data in most cases.
With email you have a better electronic "paper trail", and more Send/Receive options
(Priority, Multiple recipients, Delivery Receipts, Signatures, attachments, formatting, ...etc)

I know you sated that:
 "Client rejected internet service based solution"
 ...but you did not specifically state if "email" fell into this category as well...

Typically a paper document is scanned, saved as a disc file then, emailed as an attachment.
Newer "Multi-Function" devices (Scanner/Fax/Printer/Copier) will scan a paper document and provide the ability to email the scanned document immediately.

I am sure an Expert here can help you with the faxing directly, ...I am just interested in why Email is not an option.

JeffCoachman
0
 
KapriceAuthor Commented:
Email IS an option. Just not an EXCLUSIVE option. And, we're not scanning documents to fax.

We generate our invoices from the Access db. Each client has a "Delivery Preference" field. In it, we can put E, F, or P for Email, Fax, or Print (snail mail).

I've got the Print and Email features down. Now, I just need help with the Faxing feature.
0
 
IrogSintaCommented:
Maybe you could see if SendObject would work in your case.  
DoCmd.SendObject acReport, "NameOfReport", acFormatRTF, "[fax: " & strFaxNumber & "]", , , , , False

Open in new window

Here's a link from Microsoft support about this:
http://support.microsoft.com/kb/231797
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
KapriceAuthor Commented:
I read that KB and I'm still confused. What is actually controlling the Fax Modem with SendObject?

And, I can't tell what, if any, other apps are required for it to work, such as Outlook or Exchange.
0
 
IrogSintaCommented:
I believe the link mentioned that Outlook was needed, not Exchange.  

Why don't you just try a quick test?  
Private Sub TestFax()
    Dim strFaxNumber as string, strReportName as string
    strFaxNumber = "put fax number here"
    strReportName = "put name of report here"
    DoCmd.SendObject acReport, strReportName, acFormatRTF, "[fax: " & strFaxNumber & "]", , , , , False
End Sub

Open in new window

0
 
KapriceAuthor Commented:
Running your sample code, I get this error:

"Your Microsoft Exchange Server is not available."
0
 
IrogSintaCommented:
Hmm, I'm not sure I could be of help now.  I don't have Microsoft Exchange Server installed and I don't get this message.  The only thing I found is perhaps you have to add a Fax Mail Transport service in Outlook.  I don't use Outlook so all I can give you is what I found:

For Outlook 2000:
    Tools -> Services menu item, select to add a service and then add the Fax Mail Transport.
For Outlook 2002:
    Tools -> Email accounts -> Add EMail Account -> Additional Server Types and
then select the Fax Mail Transport

These are just stabs in the dark.  Hopefully another expert will have something more concrete for you.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
According to a post here: http://www.pcreview.co.uk/forums/fax-ms-access-form-t1899450.html

You can send a Fax with Outlook using this terminology:

FAX:+1112223333

You must have the "fax transport" service running. I'm not sure if this just sends it, or if you must still enter other information (like a title page, etc).

Short of that, you'll have to obtain a 3rd party "printer" that you can automate through VBA.
0
 
KapriceAuthor Commented:
I'll test Outlook with Fax Transport.

Are there any good 3rd party "printers" besides FaxMan?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I honestly don't know. I haven't had to work with machine-side fax stuff in quite a while.

Seems crazy to go to all this trouble when they could spend $7/month and sign up with a service like SmartFax, where you can "email" your fax to SmartFax with the defined format, and they'll send it along to the recepient as a fax.
0
 
KapriceAuthor Commented:
I agree. My client told me they don't like being dependent on an outside company for their faxing. The company could have technical problems or just shut down. My client wants to be in full control.
0
 
KapriceAuthor Commented:
I hope to get back to testing this solution some time this week.
0
 
KapriceAuthor Commented:
Sorry for the delay. This week looks good so I hope to test with Fax Transport.
0
 
KapriceAuthor Commented:
(sigh) I really haven't abandoned this question, I just haven't been able to get back to working on this project.

Soon. Soon...
0
 
KapriceAuthor Commented:
This week. For sure.
0
 
KapriceAuthor Commented:
(sigh). I've NOT forgotten about this, but it really has taken a back seat to some more urgent products. I hope to test this out next week.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 10
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now