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: