MailLogon Method
Logs in to MAPI Mail or Microsoft Exchange and establishes a mail session. If Microsoft Mail isn't already running, you must use this method to establish a mail session before mail or document routing functions can be used.
expression.MailLogon(Name, Password, DownloadNewMail)
expression Required. An expression that returns an Application object.
Name Optional Variant. The mail account name or Microsoft Exchange profile name. If this argument is omitted, the default mail account name is used.
Password Optional Variant. The mail account password. This argument is ignored in Microsoft Exchange.
DownloadNewMail Optional Variant. True to download new mail immediately.
Remarks
Microsoft Excel logs off any mail sessions it previously established before attempting to establish the new session.
To piggyback on the system default mail session, omit both the name and password parameters.
Example
This example logs in to mail and downloads any new mail immediately.
If IsNull(Application.MailSession) Then
Application.MailLogon "oscarx", "mypassword", True
End If