Export (0) Print
Expand All
Expand Minimize

Application.UserAddress Property

Office 2007
Returns or sets the user's mailing address. Read/write String.

Syntax

expression.UserAddress

expression   An expression that returns an Application object.

Remarks

The mailing address is used as a return address on envelopes.

Example

This example sets the user's return address. The Chr function is used to return a line feed character.

Visual Basic for Applications
Application.UserAddress = "4200 Third Street NE" & Chr(10) _
    & "Anytown, WA  98999"

This example returns the address found in the Mailing address box on the User Information tab in the Options dialog box (Tools menu).

Visual Basic for Applications
Msgbox Application.UserAddress



Community Additions

ADD
Show:
© 2014 Microsoft