Try one of the following to query on the last email sent from NetCommunity:
  1. Use a Raiser's Edge email query to globally add action records (BB1436) to use action query fields.
  2. Use a Raiser's Edge email query to globally add appeals to constituent records (BB10586) to use constituent appeal query fields.