Jump to content

Reporting on Emails

Recommended Posts

I'd like to create a report which shows emails received by our local customers (those which are "Basic" users in SM).

Which tables etc do I need to link together to make that happen?

Many thanks everyone.

Link to comment
Share on other sites

If it helps, the "From" content appears to be the persons surname a comma then a space and their first name.


Perhaps some statement to match that against h_sys_accounts?

h_sys_accounts.surname & ", " & h_sys_accounts.firstname

Tried this, no joy.. Will keep fiddling.

Link to comment
Share on other sites

I discovered it was easier to simply report on those which did not have the "@" symbol in the "From" field, those internally received emails were showing the "From" field contents as Surname, Forename.


Thank you all.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...