Sending email without using outlook, etc (1 Viewer)

Status
Not open for further replies.

keiths

Registered User.
Local time
Today, 06:36
Joined
Feb 10, 2005
Messages
28
I found a very handy dll that allows you to send email from within your ms access database (also ms excel). This allows you to send email without the use of ms outlook or other email clients.
The web site for the dll is:

http://www.ostrosoft.com/smtp_component.asp

The zip download includes a number of samples for different programming languages. What I liked about this smtp email dll is that I can set up a "monitor window" where I can see what is happening with the smtp server so I can see errors, etc.
The coding is fairly straight forward, and is easy to implement.

I removed some of the samples for other programming codes, and it is attached here.

They also have a dll for reading emails. Have played with it a bit, and it also seems to work fine.
 

Attachments

  • OSSMTP.zip
    247.6 KB · Views: 7,838

keiths

Registered User.
Local time
Today, 06:36
Joined
Feb 10, 2005
Messages
28
Sample Database for sending emails

I was asked by some members of this forum if I could supply a sample database showing the use of this dll. Attached is a sample db, along with the dll. You must put the dll in your \windows\system folder, and register it before you can use this database.
The database includes a simple "pick list", so you can pick members with valid email addresses to add to the cc or bcc fields.
Also, there is included the functionality to add attachments to the email.
...Keith
 

Attachments

  • email-db.zip
    204.6 KB · Views: 5,048

ranjah

Registered User.
Local time
Today, 07:36
Joined
Aug 25, 2005
Messages
22
Just how exactly do we register these dll files?? Also do they go into system32 or system folder?
thanks
 

keiths

Registered User.
Local time
Today, 06:36
Joined
Feb 10, 2005
Messages
28
Using the DLL

Put the DLL in the windows/system folder. Register it using the command

" regsvr32 OSSMTP.dll " from a command prompt.

Or, find one of the slick utilities that are out there for registering DLL's.
 

gschimek

Registered User.
Local time
Today, 07:36
Joined
Oct 2, 2006
Messages
102
This works great! Any idea how to make it send batch emails? I'd like to send confirmation emails to 50-60 people at once.
 

keiths

Registered User.
Local time
Today, 06:36
Joined
Feb 10, 2005
Messages
28
I am not sure what you are refering to regarding "batch emails".
It already will send an email to multiple people, with an attachment.
If you want it to do "more" then you need to write the appropriate
vba code to do it. The dll itself handles all the rest.
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom