Best language to write Outlook app

[sergeiY]

Hi

I need to write a small app that will scan newly coming e-mails and resend them via SMS gateway ... friend of mine wrote a VBA script in Excel to read/send e-mails but I seems to me as not right choice for a task ... so my question is: what is the right choice of programming language ? is it VB, Excel/Outlook VBA scripting or something else ?

I would also be very grateful if you can direct me in right direction and provide links to good FAQs or other resources.

Thank you

 

[danvlas]

Excel, Word, Access, Outlook, PowerPoint are programs that you use for a specific purpose. From time to time, you need let's say in Excel the functionality of Outlook to create email messages, appointments, tasks. You will use Outlook as an ActiveX object programmable from Excel.

Other times you may need Access to create and fill in an Excel spreadsheet. You will use Excel as an ActiveX object programmable from Access.

Or you have a VB program that has to woork with any/all above mentioned products. Again think of them as ActiveX objects controllable via VB.

All is done in VB(A). The language is the same, only the methods and properties are different from an object to another.

To start, you have to create the object in your main application:

Set olObj = CreateObject("Outlook.Application&quot
Set xlObj = CreateObject("Excel.Application&quot
Set wdObj = CreateObject("Word.Application&quot
Set pptObj = CreateObject("PowerPoint.Application&quot

From this point, olObj, xlObj, wdObj and pptObj will 'know' all objects, methods and properties of that application. All you have to do is call them appropriately.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[sergeiY]

Cool. So you're saying VB is a way to do it. That's excelent. I wasn't sure if it is easier or harder to do it from outside of Outlook.

Thank you

Sergei