I'm trying to figure out a good code to use to send an email from Access 2007 through a smtp server. The email source I'm trying to use is godaddy, if that helps. All the codes I've found so far for smtp email, I change to fit our settings, and this error "A problem occured while Microsoft Office Access was communicating with the OLE server or ActiveX Control" always comes up. Also, all the smtp code doesn't show how to send a specific report, just file attachments from a root path. I know Outlook code, and to specify a certain report, and pdf, and whatnot... but outlook is not making anyone happy. Any help would be greatly appreciated.
Thanks!
alyon