Rocky Smolin
rockysmolin at bchacc.com
Sat Sep 12 14:00:59 CDT 2009
Answer to your first question is in Steve's opening: "old client...who continues to use Paradox for DOS for the majority of his business..." How quaint. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Saturday, September 12, 2009 10:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Winfax Pro and Access First question is why does he receive requests for bids by fax. Is it because that's the way is clients want to do it or is it because they don't know that they could email them to him. You need to find out what would be the effect of requesting his clients to use email instead. That will help determine the most suitable solution. These days, if you have an "All-in-one" printer/scanner/fax (I use an HP Officejet J4500), you can just print an Access report to it and it will interface to your Addressbook with all of your customer details. No need for third party software such as Winfax. Emailing PDFs and the like can get a bit tricky using just VBA and Outlook, but there are plenty of alternatives methods - including printing to a PDF printer and then using Blat or using Ghostscript and a utility I wrote called MailPDF which you can find on my website at http://www.lexacorp.com.pg under Downloads. I've got one system with a client which sends out several thousand PDF invoices as email attachments every month - all done through a mash up of Access, MakePDF, Blat and a another small PowerBasic application to tie them together. -- Stuart On 12 Sep 2009 at 11:46, Steve Erbach wrote: > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com