About the Other People at Same Company Table Message Part

This part uses a SQL statement to specify that the Data Table Base Part should display a table of all other Persons who are at the same company as the message recipient. See Creating a Derived Part for more information on this type of message part.

This part provides these input values for the Data Table:

• SQL: SELECT FirstName,LastName,Title,Email1,CompanyID FROM APTIFY.dbo.vwPersons WHERE CompanyID=<%CompanyID%> AND ID<><%ID%> ORDER BY LastName, FirstName
• Title: People at Your Company in OUR DB

Note that the other optional input properties are not specified and they use default HTML settings.