Professional FoxPro Development.
Support You Can Count On.

 

Import Emails Into FoxPro Tables

Just Drag, Drop, and Import!
 

FoxPro 9.0 example of email drag/drop By using pre-formatted e-mails such as the one to the right, you can enhance your custom software application to drag and drop emails from Outlook, then import the data directly into your database. No rekeying of data is needed!

These particular emails are auto-generated by a client's web site whenever that client adds new users, or request changes to their user data.

You could also create a form in Outlook (or other email applications), and use it to guide users in providing the key fields you need to import.

When they receive e-mails of this type, office personnel drag/drop the e-mails onto a grid in the form below. They can then review all the details by pressing the review button, which launches a child form as shown.

Then users select which records to import by clicking the Import checkbox to the left of each record, and finally pressing an Import button.

 

VFP importing text from email

As users select records to import the background color of each record changes color, to provide additional visual cues. We also use additional background colors to indicate the status of each record (for example, records that already exist but are being deactivated are given a different background color.)

 


IO Technologies Inc
I/O Technologies, Inc.
N116W15830 Main St. STE 101
Germantown, WI 53022-2603
800-993-9028

Sign up for our e-Newsletter