Microsoft Excel

In Microsoft Excel, MAPI is hosted by the Microsoft Visual Basic®, Applications Edition language. Microsoft Excel/Visual Basic for Applications actually provides some very basic mail services within the Microsoft Excel object model, specifically:

• The MailLogon method. This method can be used to log on to the mail system and establish a new session.

• The MailLogoff method. This method can be used to log off the mail system.

• The SendMail method. This method can be used to send a workbook to a specified recipient.

• The MailSession property. This property returns the session ID created by the MailLogon method and can be used to drive "real" MAPI calls.

More complex requirements can be met by using the power stored in the following:

• MAPI.DLL

• VBMAPI.DLL.

These two DLLs provide the full set of MAPI functions which can be declared within a Visual Basic for Applications module. In addition, there are a set of Visual Basic for Applications routines that can be used to better integrate MAPI with the Microsoft Excel–provided mail methods and properties.

The full set of declarations and support routines are provided and described in the Microsoft Excel sample application described later in the paper.