Sending Foxpro Report To Fax or Email

[1421]

Hi All,

Does anyone know how to send a report to a fax or email address, progromaticly from Foxpro. Client is using VFP Ver 6.

Thank You

 

[JRB-Bldr]

There are a variety of approaches to make this happen.

I have set up one of my clients to use Outlook to send both Emails and FAX's.

To send the FAX's you need to utilize the Microsoft Shared FAX Services and configure Outlook to utilize it when it sees the email address arrive like "fax: 1-123-45678"

For emails it is easier.
To utilize Outlook I have them also using Redemption.dll to get around the Outlook security prompt Yes/No.

I send these documents by using Automation within the VFP application.

Utilizing this method, my client typically sends out 400+ emails and FAX's each day to its clients.

If this is a workstation application only you have some other options such as using WinFAX for your FAX's.

In addition to possibly using Outlook, you can also search this forum to see how others are using CDO to send emails.

Good Luck,
JRB-Bldr

 

[1421]

Thanks for your answer, but what do you do on the Foxpro side as far as code etc.

 

[JRB-Bldr]

On the VFP side you use Redemption Automation to 'drive' Outlook with what you want it to do.

In my client's case...
For Email:
1. Create DOC file (attachment) from VFP Report Form using FXP2DOC
2. Create Excel File (attachment)
3. Pass Email info (To address, From address, attachment filenames + paths, etc.) to Outlook through Redemption via Automation.
4. Issue SEND through Automation

For FAX:
1. Create TIF file (attachment) using workstation 'Image Print Driver'
2. Pass FAX info (FAX No., TIF Filename + path) to Outlook through Redemption via Automation.
NOTE: The TIF 'attachment' becomes the FAX document automatically via the Microsoft Shared FAX Service
3. Issue SEND through Automation

Good Luck,
JRB-Bldr