You will need to get the smtp server address of your Exchange (or other) server to enter in the smtp server dialog. The you need to enter the necessary credentials.
As regards the mapped drive issue, just use a UNC path instead, and it will work fine.
E.g. fileservernameABLGRPClientsBi-Proauto esting.xprj
As regards creating one row per transaction, that will seriously impact performance, but it can be done.
It is rather involved, so if you could e-mail me at email@example.com[/email] with your contact telephone, I can give you a call.
Could not access 'CDO.Message' object.
In short Email not working SMTP can’t set it up correctly I’m using an Outlook email account.
Could not find a part of the path "W:ABLGRPClientsBi-Proauto esting.xprj". at System.IO.__Error.WinIOError(Int32 errorCode, String str)
In short projects will only work locally although I can browse all my shares for projects therefore I need assistance with permissions/ID’s to overcome this hurtle
Most important is how to setup the Oledb to populate the target table via a cursor, or one row at a time.
The tables in my db have index options of unique values that must be maintained, or conversely how to call a Stored procedure (vendors code) so that the incoming data is filtered by a stored procedure that will cursor one row at a time in to the target table?