this is a followup post to the archived posting at SMTP code for VBA?
Assuming you want to send email from Access with your own completely customized message body, perhaps in HTML, perhaps in plain text, but you don't have or need Outlook and want a solution that is deployable to client machines without needing any third party components, then see the sample code at ** Link removed as per site rules **
This code also shows you how to create a COM (ActiveX) compliant DLL using VB.NET 2008 (the same principles work exactly the same way on .Net 2003 and .Net 2005. COM compliant DLLs, or ActiveX DLL's as they used to be known, are accessible from any VBA or VB5 / VB6 application.
Assuming you want to send email from Access with your own completely customized message body, perhaps in HTML, perhaps in plain text, but you don't have or need Outlook and want a solution that is deployable to client machines without needing any third party components, then see the sample code at ** Link removed as per site rules **
This code also shows you how to create a COM (ActiveX) compliant DLL using VB.NET 2008 (the same principles work exactly the same way on .Net 2003 and .Net 2005. COM compliant DLLs, or ActiveX DLL's as they used to be known, are accessible from any VBA or VB5 / VB6 application.
Comment