Access Outlook from Visual Basic Application

[Ebenezer]

hie friends,

I have Microsoft Outlook 2007 installed in my computer system. I want to access Outlook 2007 from VBA (i.e. Visual Basic Application). My question is - Is it possible to access outlook from VBA ? If possible, then how ?
please give necessary info regarding same...thnx

[Eric B]

Yes, it is possible to control Outlook from any program written with Microsoft Visual Basic with the help of a supporting Automation feature of Microsoft Outlook.
Automation provides a standard method for one application to access the objects, methods, properties, and events of other applications that support Automation.

[chroma]

If you are using VBA to create macros, there are two ways you can automate Outlook.

• You can implement a macro that creates a new instance of the Outlook Application object.
• You can implement a macro that creates a current instance of the Outlook Application object.

For the detailed information on both the methods along with the sample code , click on the following link

http://msdn.microsoft.com/en-us/library/bb206737.aspx

[Sam.D]

If you are developing a cross-application solution using one primary application and several secondary applications, you can write VBA code in the primary application to automate Outlook to send messages and to store and retrieve information in Outlook items.
For example, in Microsoft Office Excel you can write routines that send a workbook to an Outlook distribution list.