Sending emails from Acess Database

[Lirizarry]

Recently created a database with a form that the user provides problematic information. The form has a close button that has a macro attached that initated an emails and send the form information in a report to the end user . My problem is the function works great when the sender has a Outlook account. When the sender has a gmail account - the command will not work. I read that VBA can be written but I am not able to write SQL. Can anybody help me with a go around. My level with access is using built in functions and commands.

[June7]

SQL is not VBA. VBA can process SQL statements but SQL not required for VBA coding. Will need VBA code for what you want.

Review this
http://www.emailarchitect.net/forum/...?g=posts&t=130

[Lirizarry]

Thanks for your reply. At my level knowledge I'm not familiar with either. I checked out the link you posted. If I copy and paste that will it work as is. Do I paste it into the micro or VBA area.

[June7]

I can't vouch for the reliability of this code. You have to test. It is VBA, not macro.

You will certainly have to change the hard-coded values, such as recipient email, subject, etc.

I have no idea what the lines about server port are about.

Review this
http://office.microsoft.com/en-us/ac...010341717.aspx