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.

Jul 21 '05 #1

Subscribe Reply

1312

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

Jul 21 '05 #2

David L

Okay that makes sense. Thanks Joshua.

Joshua Flanagan wrote:

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

Jul 21 '05 #3

Similar topics

4611

Shelton/C# should be able to match my HTM_TXT.EXE .

by: Jeff_Relf | last post by:

Hi Tom, You showed: << private const string PHONE_LIST = "495.1000__424.1111___(206)564-5555_1.800.325.3333"; static void Main( string args ) { foreach (string phoneNumber in Regex.Split...

.NET Framework

2148

What dir executing is done from

by: Mads W. | last post by:

I want to read an ini file which is located in the same dir as my .exe file. But how can I do that without having to have the excact same dir for all my program installations. Let me try to...

C# / C Sharp

2520

Framework 1.1 / Access Unspecified Error

by: RM | last post by:

Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ...

ASP.NET

2062

WebServices break after upgrade to Framework 1.1

by: Joseph Geretz | last post by:

I recently upgraded my server to Windows 2003. The first thing I noticed is that my sample WebService pages no longer worked. The Invoke test button is missing. This is addresed by the following KB...

ASP.NET

3183

Error: Failed to start monitoring changes - Framework 1.1

by: Tim D | last post by:

Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...

ASP.NET

5832

Push Server, Remoting Over Http,Real Time Data,Streaming, How Is this Done?

by: batista | last post by:

Hi there, I want to push data from server to client.(No pulling and no "smart pulling" like using xmlhttp) I heard that one possible solution is to use TCP connection using ActX Controls or...

ASP.NET

3501

Injecting local variable to a function - Can it be done?

by: tai | last post by:

Hi. I'm looking for a way to define a function that's only effective inside specified function. Featurewise, here's what I want to do: bar_plugin_func = function() { ...; setTimeout(...);...

Javascript

2786

Force GPRS Sync during Debugging. Can this be done?

by: iKiLL | last post by:

Hi , I am trying to debug a problem with a Windows Mobile Application. I need the PDA to Sync(I have writen the sync process myself using a web service) using GPRS while Debugging from the VS...

C# / C Sharp

6611

Installing Net Framework Service Pack 1

by: dancer | last post by:

I have made a new post because when I try to respond to another, I get the error, "Article Rejected -- Ill-formed message id" This is in response to the advice of Juan Libre to install Net...

ASP.NET

1977

Casting a Windows Handle. Can it be Done?

by: ink | last post by:

Hi all, If I have a Windows 32 pointer to and object (Handle) and I know what that object is (Button) can I some how cast that pointer to a type of System.Windows.Forms.Button and then use its...

C# / C Sharp

7120

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6991

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7160

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7196

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

5456

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4583

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3078

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1405

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

649

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP