473,804 Members | 3,277 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB & Access Send Email

35 New Member
Hai,
I need to send and receive Email's using VB and Ms-Access. Am using the following code. If i run this code, i has the error message as,

Compile Error
User-defined type not defined in the code for New clsSendMail

Private Sub Command0_Click( )
Set poSendMail = New clsSendMail
poSendMail.UseA uthentication = True
poSendMail.UseP opAuthenticatio n = True
poSendMail.POP3 Host = "pop.gmail. com"
poSendMail.User Name = "ttamilvana n81"
poSendMail.Pass word = "classic"
poSendMail.SMTP Host = smtp.gmail.com
poSendMail.SMTP Port = 465
poSendMail.from = "ttamilvanan81@ gmail.com"
poSendMail.From DisplayName = Tamilvanan
poSendMail.Reci pient = "ephrontamizhva nan@gmail.com"
poSendMail.Reci pientDisplayNam e = "EphronTamilvan an"
poSendMail.Repl yToAddress = "ttamilvanan81@ gmail.com"
poSendMail.Subj ect = "Test Mail for How to Send E-Mail"
poSendMail.Mess age = "This is a test"
poSendMail.send
End Sub

If anyone know how to run this code, if any components or tools can i installed?

if anyone knows, please let me know.

By
Tamilvanan
Mar 29 '07 #1
6 4667
vijaydiwakar
579 Contributor
Hai,
I need to send and receive Email's using VB and Ms-Access. Am using the following code. If i run this code, i has the error message as,

Compile Error
User-defined type not defined in the code for New clsSendMail

Private Sub Command0_Click( )
Set poSendMail = New clsSendMail
poSendMail.UseA uthentication = True
poSendMail.UseP opAuthenticatio n = True
poSendMail.POP3 Host = "pop.gmail. com"
poSendMail.User Name = "ttamilvana n81"
poSendMail.Pass word = "classic"
poSendMail.SMTP Host = smtp.gmail.com
poSendMail.SMTP Port = 465
poSendMail.from = "ttamilvanan81@ gmail.com"
poSendMail.From DisplayName = Tamilvanan
poSendMail.Reci pient = "ephrontamizhva nan@gmail.com"
poSendMail.Reci pientDisplayNam e = "EphronTamilvan an"
poSendMail.Repl yToAddress = "ttamilvanan81@ gmail.com"
poSendMail.Subj ect = "Test Mail for How to Send E-Mail"
poSendMail.Mess age = "This is a test"
poSendMail.send
End Sub

If anyone know how to run this code, if any components or tools can i installed?

if anyone knows, please let me know.

By
Tamilvanan
If u've received this code from some where else then ask for the class module named clsSendMail
ur project don't have this module simply place this module and run the code
Mar 29 '07 #2
ttamilvanan81
35 New Member
If u've received this code from some where else then ask for the class module named clsSendMail
ur project don't have this module simply place this module and run the code
Hai,
You are Right, iam get this code from another person. But i don't receive any class module named clsSendMail. So thats why i am asking this.

Kindly, if you know this, please let me know....

Thanks

Tamilvanan
Mar 30 '07 #3
vijaydiwakar
579 Contributor
Hai,
You are Right, iam get this code from another person. But i don't receive any class module named clsSendMail. So thats why i am asking this.

Kindly, if you know this, please let me know....

Thanks

Tamilvanan
how could i no what he had coaded for that module
Mar 30 '07 #4
ttamilvanan81
35 New Member
how could i no what he had coaded for that module
Hai,
I am sending mail using your code as your earlier post. But i can't got the clsSendMail class module. Can you please send me that class module.

and i need to attach the file in mail. So if you can know, how the attachments will be working, kindly post me the details.

Is this code need any ActiveX control or components, please let me know that details also.



Thank,
By
Tamilvanan
Mar 30 '07 #5
ttamilvanan81
35 New Member
how could i no what he had coaded for that module
Thank you very much.
If you know how to attach the file like, click the browse button and select any one file to attached in email.

If you know how to attach file in the above format, kindly let me know.

Thanks

Tamilvanan
Mar 30 '07 #6
vijaydiwakar
579 Contributor
Thank you very much.
If you know how to attach the file like, click the browse button and select any one file to attached in email.

If you know how to attach file in the above format, kindly let me know.

Thanks

Tamilvanan
i think i've just posted the code for that
Mar 30 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

14
1865
by: CJM | last post by:
I have a query which produces different results in the Access query builder and in an ASP page (via ADO) An example of the query is: ---------------------------------------------------------- Select 'Ranked' as Source, H.HotelName, H.TelNo, H.URL, H.Location, H.HotelID, Rank from (Hotels H Inner Join PrefHotels P on H.HotelID = P.HotelID) Inner Join Locations L on P.LocID = L.LocID where Rank is not null and Rank > 0 and L.LocID=2
3
5071
by: Philippe Lang | last post by:
Hello, How can open a unix shell from a PLPGSQL function / trigger? I would like to send an email from a postgres database, and also send some unix commands to the server, through the database... Thanks ------------------------- Philippe Lang
4
5534
by: JvdWal | last post by:
Hi, I've been trying the PDF & Mail Class Library from ACG Soft in combination with Northwind-2k3 style of db. Can someone help me with the error which is popping up: (which I cant get solved..) I'm trying to send a report in PDF-format with a unique QuotationID to one specific customer by Email. >> Button in a form >> quotation-report and a "filter and printfilter"- query..
4
5448
by: Grady | last post by:
Hi. I need to create a simple database that tracks equipment arrivals at my facilities. What I want is to create a simple form, which the receptionist could fill out, every time someone delivers something at the front door. The form would simply have a place to put the time/date, delivery method, addressee, and a brief description. Once the receptionist filled it out and hit enter it would create a new record and then send a summary...
5
17666
by: Lauren Wilson | last post by:
Hi folks, Somewhere, I recently saw an article header titled: "How to compact and Repair a back-end Access db from the front-end using VBA" or words to that effect. Now that I need it, I cannot find it. Does anyone know were to find such an article?
27
3863
by: Daniel Vallstrom | last post by:
I'm having problems with inconsistent floating point behavior resulting in e.g. assert( x > 0.0 && putchar('\n') && x == 0.0 ); holding. (Actually, my problem is the dual one where I get failed assertions for assertions that at first thought ought to hold, but that's not important.) At the end is a full program containing the above seemingly
15
2519
by: Dino Vliet | last post by:
Hi folks, probably this is a question you've heard so many times but I wasn't able to find a solution to it. I'm using a shell script to create a textfile for me. It looks like #!/usr/local/bin/bash psql -c "select foo from bar;" -d database1 -t psql -c "\q" -d database1 exit 0
39
4741
by: dancer | last post by:
Can somebody tell me why I get this message with the following code? Compiler Error Message: BC30452: Operator '&' is not defined for types 'String' and 'System.Web.UI.WebControls.TextBox'. <html> <head> <% @Import Namespace="System.Web.Mail" %>
1
4368
George Lft
by: George Lft | last post by:
ok, first of all, i built my register page using dreamweaver tool which the codes haven been out of control. Now i'm thinking that turning over everything - by using this another set of codes. And these new sets of codes have overwhelmed me a bit. Here's the new code: CREATE TABLE `users` ( `ID` int(11) NOT NULL auto_increment, `Username` varchar(255) NOT NULL, `Password` varchar(255) NOT NULL, `Temp_pass` varchar(55)...
0
9708
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9587
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10340
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9161
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6857
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5662
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4302
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 we have to send another system
2
3827
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2998
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.