Gets the e-mail name of the specified SharedWorkspaceMember in the format user@domain.com. Read-only.

Syntax

Emailexpression.Email

expression An expression that returns a SharedWorkspaceMember object.

Example

The following example extracts the e-mail domain name from the Email property of each shared workspace member and lists members who have e-mail addresses at the "example.com" domain.

Visual Basic for Applications 
Dim swsMember As Office.SharedWorkspaceMember Dim strEmailDomain As String Dim strMemberList As String For Each swsMember In ActiveWorkbook.SharedWorkspace.Members strEmailDomain = LCase(Right(swsMember.Email, _ Len(swsMember.Email) - InStr(swsMember.Email, "@"))) If strEmailDomain = "example.com" Then strMemberList = strMemberList & swsMember.Email & vbCrLf End If Next MsgBox strMemberList, vbInformation + vbOKOnly, _ "Members with example.com e-mail" Set swsMember = Nothing
email email property ofv

See also: