Email customers from database?

[DK47]

My program wll supply retailers with email addresses for potential customers.
Can VB6 be coded to automatically email each customer if the email is highlighted and clicked either from the data grid or a text box bound to the server?

I am relatively new at VB6 and have purchased a few books but have not seen this function in any of them.

I've been told that if I can conceive it, VB6 can do it.
Hope that's true for this application. It will be a great selling point for the program if the user can easily email.

Any help will be appreciated.
Thanks,
Dwight

 

[eramgarden]

Look into CDO and/or Outlook dll.

On msdn website, do a search for "CDO"..collaboration data objects.

 

[Merlijn]

You could use the vbSendMail.dll
Search the internet for it. It comes with examples.
Very handy if you do NOT use M$-Outlook. Because if you don't, you haven't got outlook.dll.

Merlijn is the name, and logic is my game...

 

[DK47]

Merlijn,
Thanks for the info.
I'll find that file and work with it and let you know how I make out.
Thanks Again,
Dwight

 

[tb]

Using sql you can use xp_sendmail

"All I ask is the chance to prove that money can't make me happy." - Spike Milligan

 

[fatboy2]

If you are using outlook express, you are limited to simple MAPI functionality. I have an app that needed to attach files to an email, which turned out to be outside the realm of simple MAPI. I had to use Outlook for that. Check this article in MSDN knowledgebase. Article Q161088. HTH.

 

[Merlijn]

fatboy2, that is exactly the reason why I suggested vbSendMail. It is free, can send and receive mails with or without attachments.
I use it in the administration program that I'm extending at work.
Works quite well actually.

Merlijn is the name, and logic is my game...

 

[Merlijn]

Use following link to find vbSendMail

http://www.freevbcode.com/ShowCode.Asp?ID=109

Merlijn is the name, and logic is my game...

 

[DK47]

Merlijn,
Thanks for all your help.
I've installed the dll in my VB6 directory and will begin working with it soon.
If I run in to trouble I'll reach out to you.
Thanks again.
Dwight