We have an Access 2007 project that incorporates a facility to email directly from within the source.
The code is in place but returns an error as follows:-
"The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available [-2147220975]
Email unsuccessful. Please check your SMTP Server and Email details and try again"
We are not familiar enough with the code for this function to debug it, and are looking for a competent coder to recode / resolve the issue for us.
## Deliverables
The attached ZIP file contains the part of the project relevant to this bid request including a form to test the email facility.
Extract the files, and open whilst holding the CONTROL key down to view design mode. The form to test the Email function is called 'frmSettEmailPU'
The email details including smtp server name, smtp server user id, and smtp server password are known working credentials and may be used to test this project.