[AccessD] Winfax Pro and Access

Steve Erbach erbachs at gmail.com
Sat Sep 12 11:46:49 CDT 2009


Dear Group,
I have an old client (started working with him right after I started my
business in '91) who continues to use Paradox for DOS for the majority of
his business.  I'm his go-to guy for all of that work as well as for Paradox
for Windows, which I introduced into his company to produce more flexible
reporting, and Access 2003.  I wrote an EDI component for processing
purchase orders in Access using a VBA EDI library I recommended he purchase.

Anyway, I've been trying over the years to get him to switch completely to
Access or SQL Server but I don't think that it's ever going to happen.

During the time I've worked with him he's had an idea for electronic
document storage that he keeps running past me.  We talked about it again on
Thursday this past week.

He receives requests for bids via fax.  Sometimes these documents are a
couple dozen pages long.  He doesn't bid on every item on every page; so
he'd like to save only those fax pages that contain the items he bids on.
 He wants to save those pages in another file for reference without having
to print a hard copy at all.  In the last 12 months he responded to over
1400 bid requests.

He also wants to create PDF documents for his invoices and order
acknowledgements...again, without having to print them.

His thought is to use Access as the mechanism for automating his faxing.  If
he has to send out 10 bids in a day, with three of them to the same company,
he wants to be able to control a fax program (WinFax Pro is the only one I'm
really familiar with) through Access to send faxes to multiple companies,
with multiple documents to the same company.

I suggested that he consider sending e-mails instead with attachments.

1) What kind of experiences have you had using Access to control WinFax Pro?

2) I've seen messages here relating to controlling Outlook with VBA.  What's
your feeling about the desirability of that sort of operation?

Regards,

Steve Erbach
Neenah, WI



More information about the AccessD mailing list