>I took the wrong path and now I am back..
>I was attempting to loop through a Lotus database to validate email addresses before I sent an email through my FoxPro App via ole automation. I could not find an efficent way to do this, therefore, I would like to export the lotus database (names.nsf) to either a Fox table or Excel sheet(where I could then import the excel sheet into a fox table) and then run my validation routine on a Fox Table.
>My research on this provided no insight on exporting from a Lotus table.
>Any helpful tips would alleviate my pain.
>

Wes,
Notes gives you the ability to export to a WK? (1-2-3) spreadsheet which you can open with Excel, create an XLS out of it and import that into VFP. You can also export to a CSV file (I believe) and import from that.

What is the frequency that you want to do this? Everytime you send an e-mail or periodically? If periodically, then I would recommend using a COM approach to read and insert the names from one of your Views into a VFP table. You could then run the same process every night (or more frequently) to sync your address books.

As for validation in general, I recomend doing away with the entire validation approach. If Notes addresses are used, Notes does validate them against the global addressbook. If a bogus address is found (or one that can have multiple matches), it stops the automatic send until the address can be verified. It is for this reason I always use the Internet address even if sending internal e-mail. Notes doesn't validate messages with this structure. It simply sends it to the SMTP gateway to process. If the gateway can't find a match on the domain or the domain postmaster sends something back, that message gets sent to the sender of the message so they will know if something didn't get sent correctly.

It does add a little overhead for internal mail because the mail gets routed to the SMTP gateway to process and then gets routed back after being translated, but that usually isn't a big deal.

HTH.