can this be done? make use of the .net framework using VBA

[David L]

Hi, wondering if i'm asking the impossible.
Got an Access database, and i wish to use the .net framework's smtp
facilities from within Access's VBA. Is that possible? If so, what to
do? I've been searching the net but no mention of anything like it so far.
Any thoughts appreciated.
Regards,
David.

 

[Joshua Flanagan]

Not impossible, just not necessary.

You could expose a .NET assembly as a COM object by creating a COM
Callable Wrapper, but that is completely unnecessary in this case.

If you are just looking to use the SMTP facilities in .NET, then use
what .NET uses under the hood - CDO!

See this web page for an example of using the CDO objects from VBScript
(ASP in this case)
http://www.w3schools.com/asp/asp_send_email.asp

You should be able to use the CDO COM objects from VBA in Access in a
similar way.

Joshua Flanagan
http://flimflan.com/blog

 

[David L]

Okay that makes sense. Thanks Joshua.