Skip to content
+1-888-319-3663

COMMUNITY FORUM

Finding email address

Curtis asked 7 years ago
I have a front end website that transfers the data to GP and I need to use smartlist to run a report. How do I find the data field ? It is under Customer Maintenance, in the TO: filed under send email statements. Any help will be greatly appreciated. CM
Answers
Best Answer
Jared answered 7 years ago
You can find the Email Recipient field in the RM Statements E-mail Addresses(RM00106) table.  You would want to link this table to the RM Customer Master table to be able to see more information as the RM00106 only has the email information.
curtis replied 7 years ago

How do I do that ?

Jared answered 7 years ago
In SmartList Builder you need to add the RM Customer Master table and select the fields you would like to display.  You would then link the RM Statements Email Addresses to the RM Customer Master table on the Customer Number field and select the Email Recipient field.  

If you are unsure on how to do this I would take a look at the SmartList Builder manual available on our downloads page or consider taking some SmartList Builder online training available on our Events page.

If you would like to submit an answer or comment, please sign in to the eOne portal.