UserAddress Property
TOC
Collapse the table of content
Expand the table of content

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



Show:
© 2016 Microsoft