편집

다음을 통해 공유


Application.MailLogon method (Excel)

Logs on 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.

Syntax

expression.MailLogon (Name, Password, DownloadNewMail)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data type Description
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 from 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 on to the default mail account.

If IsNull(Application.MailSession) Then 
 Application.MailLogon 
End If

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.