MSSQL to SOAP

The project requires building a utility/program which sends data from our CRM software (Act! by sage) via an xml soap link to our business partner. We will need to send the data and record the response returned within a field in Act by sage. It is important to note that ACT is a CRM (Customer relationship manager) using MSSQL, therefore the data sent will be relative to each contact/customer. The data sent will include name, address, home and employment details etc. for each contact/customer we choose to submit via soap. ## Deliverables There are various examples from our partner for the soap link in a Visual Basic 6 project, and in a DLL. Therefore there should be limited "coding" work to do. The CRM software is called ACT! By sage ??" [[login to view URL]][1] The following link explains how you can get data from the act! database using the existing ODBC reader within the software in ACT! <[login to view URL]> Please dont forget, the key points are: * If you prefer to build a standalone "exe", this is acceptable as I can build the button that will call this to execute within ACT!. * Your built program will need to pull data from the MSSQL ACT! database and? send certain field data via soap to the business partner. * Your built program will need to populate a field in ACT! with the returned data. <!-- --> * Your program will need to be able for me to choose which contacts/customers I send via soap. i.e. one at a time, not enmasse.