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

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."


It is showing error as invlaid reference

have you tried it without using late binding?..

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.

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