You will need to firstly download and install Download the Microsoft Office XP Web Services Toolkit 2.0 or Microsoft Office 2003 Web Services Toolkit 2.01
1. Open Access/Excel.
2. Open the Visual Basic Editor(Alt + F11).
3. Click the new option on your Tools menu – “Web Service References…”
4. In your newly opened Toolkit Form click the “Web Service URL” radio button and enter this address: https://www.esendex.com/secure/messenger/soap/SendServiceNoHeader.asmx?wsdl
5. Click the search button.
6. Hopefully it has found the Esendex Send Service and listed it in the “Search Results” box. Place a checkmark to select the web service and click the “Add Button”.
7. Your Editor should now look something like this:
8. Add this code to Module1
Sub testEsendexSoap()
Dim EsendexSoapService As New clsws_SendServiceNoHeader
Dim messageGUID As String
messageGUID = EsendexSoapService.wsm_SendMessage("username", "password", "account reference", "recipient", "message body", "Text")
End Sub
Run or Call the testEsendexSoap macro you have now created.
NB you may have to update the code within the struct_messagesubmision to remove the following declaration:
the word 'type' is a reserved word in the MS VBA development language, replace this the declaration shown below:
Further information on our SOAP API is available here