Larry,
Using the com approach to insert records into my Fox table from lotus database would be the preferred approach. This is the method I intended on doing. As my research took me deeper I could not find any syntactical solution using LotusScript Back-End Classes. That is what resorted me to exporting the notes database file.
I need to sync the address book with my Foxtable every two weeks.
The error handling needs to be used because the email account being used to send the messages will never be seen by a user. If an email account is invalid then the memo needs to be printed to the screen for the user to hand deliver and a report generated of all of the invalid addresses so that they can be fixed.
As I get furthur into this method I find that I run into the problem of creating the instance of the NotesSession Object. I can easily '.initialize' the password of the default session on A particular user's computer, but I run into the problem of making the app portable on other computers. When the Session is created it automatically uses the current '.userid' to begin the session. When I try to reset the .userid to the 'system email account's userid' I get an error message, see code:
loNotes = CreateObject("Lotus.NotesSession") && create notes session
loNotes.username("CN=Wes Holden/OU=D20/0=DCA")&& initialize session with user id
loNotes.initialize("password")&& initialize session with password)

Any syntax examples would be great. I have scoured Advisor.com, LotusNotes 4.6 and Domino Server by SAMS, all over the net and several other user groups with no luck with solutions.



Thanks a million Larry.

>> Wes