Sales Statements

[Peter Kinsman]

I have a client running an AS/400 who wish to generate their Sales
Statements on a PC so that any for customers with an email address can be
emailed, any for customers with a fax number can be faxed and only the
remainder need to be printed and mailed.
I have written a VBA program which links to the AS/400 via an ODBC
connection and prints a Snapshot report for each customer. At the same
time, it adds a record to an email table if the customer has an email
address or to a fax table if the customer has a fax number.
When it comes to emailing/faxing/printing the various reports, does anyone
know of a way to email/fax/print the .snp file, rather than going through
the extraction and generation steps for a second time please?

 

[Peter Kinsman]

Since posting the original message, I have solved the printing scenario -
which
will be the bulk of customers initially - by adding a Snapshot Viewer
control
to the form, setting the file name and printing.
The next problem will be a 400 document print queue!

Peter