HOW TO SEND AUTOMATIC OUTLOOK MAILS USING VB ?

[ponnu]

Is it possible to send mails without using MAPI controls6 reference files

[ponnu]

Set outlook = CreateObject("Outlook.Application")

Set msg = outlook.CreateItem(mailitem)

Set recip = .Recipients.Add("recipient name")

msg.Type = olBCC

msg.Subject = "Test Outlook message"

msg.Body = "Message body."

msg.Send

It is showing error as invlaid reference

[jhai_salvador]

have you tried it without using late binding?..

[debasisdas]

Here is a completely different approach, the code is in form of a Oracle procedure . You need to call the Oracle procedure in VB to achieve the same.

[jhai_salvador]

thats a lot of code. why not try http://support.microsoft.com/kb/220595 since he/she is using outlook.

[ponnu]

thank you so much jhai_salvador !!! it solved the problem.the code is good one :)