Email attachment error

[Stew]

Greetings,

I have a designed a form that allows users to send an email to a list of clients from Access. There are three fields: subject, message and attachment path. If any fields are left empty I can pop up a message to the user and allow them to send the email without the particular information. However, if the path of the attachment is entered incorrectly, an error occurs. I want to capture the error to tell the user that they entered the wrong path or file name. I've used a msgbox to try to get the error number and it gives me a different 8 digit number each time. I could handle it by using a general error capture but the message would say the path is the problem when it could be any error (not that errors happen very often with my code: insert wink here). I've looked into using a browse button to find the path but I don't have the license for the Common Dialog Control. So, there it is, any suggestions or comments would be welcome.

 

[rich.barry]

Maybe you don't need a special license - or maybe I have it but just don't realise.

Anyway, a trip to

ftp://www.athree.com/pub/candace/access_downloads_html.htm

to download the Windows Common Dialog code would be well worth checking out.

There is also a slightly more rudimentary file explorer dialog code that I can dig out if the above does not work.

Richard