473,413 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,413 software developers and data experts.

VB & Access Send Email

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.UseAuthentication = True
poSendMail.UsePopAuthentication = True
poSendMail.POP3Host = "pop.gmail.com"
poSendMail.UserName = "ttamilvanan81"
poSendMail.Password = "classic"
poSendMail.SMTPHost = smtp.gmail.com
poSendMail.SMTPPort = 465
poSendMail.from = "ttamilvanan81@gmail.com"
poSendMail.FromDisplayName = Tamilvanan
poSendMail.Recipient = "ephrontamizhvanan@gmail.com"
poSendMail.RecipientDisplayName = "EphronTamilvanan"
poSendMail.ReplyToAddress = "ttamilvanan81@gmail.com"
poSendMail.Subject = "Test Mail for How to Send E-Mail"
poSendMail.Message = "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 4643
vijaydiwakar
579 512MB
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.UseAuthentication = True
poSendMail.UsePopAuthentication = True
poSendMail.POP3Host = "pop.gmail.com"
poSendMail.UserName = "ttamilvanan81"
poSendMail.Password = "classic"
poSendMail.SMTPHost = smtp.gmail.com
poSendMail.SMTPPort = 465
poSendMail.from = "ttamilvanan81@gmail.com"
poSendMail.FromDisplayName = Tamilvanan
poSendMail.Recipient = "ephrontamizhvanan@gmail.com"
poSendMail.RecipientDisplayName = "EphronTamilvanan"
poSendMail.ReplyToAddress = "ttamilvanan81@gmail.com"
poSendMail.Subject = "Test Mail for How to Send E-Mail"
poSendMail.Message = "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
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 512MB
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
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
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 512MB
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
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: ----------------------------------------------------------...
3
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...
4
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..)...
4
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...
5
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...
27
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...
15
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...
39
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'. ...
1
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
Oralloy
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,...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
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...

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.