Collapse the table of content
Expand the table of content
Expand Minimize

Application.UserAddress Property (Word)

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

expression .UserAddress

expression An expression that returns an Application object.

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

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

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).

Msgbox Application.UserAddress
Show:
© 2015 Microsoft