vba - How can I make a network connection with Visual Basic from Microsoft Access? -


We have a visual basic application inside Microsoft Access and we need to create a network connection. With VB6, WinSock was an easy-to-control, which made it possible, but I did not get anything to snatch the VB version inside Microsoft Access. Any ideas?

Since I am not getting any answers, I will try to clarify what I want for it.

My application sends an email, and we currently use the built-in Outlook object to create a message and send it in the background. The drawback is that it prompts the user to approve an "external program" to send an email, which frustrates our users and seems unnecessary. The other email options I can search online are either to download or purchase, which will be very laborious for us to deploy all of our users.

I was hoping to manually use a socket control to connect to the SMTP server and send a message (since it is trivial in other languages) but I have to make a TCP connection in VBA Can not find any way.

I just settled this issue last month. For various reasons, the CDO was not enough, the path of MAPI was very complicated, and Outlook complained about you completely unacceptable.

This access is widely used by developers, although I think it is very complicated and not very well documented. But this work is doing quite well.


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -