Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Possible to display Cu...

Possible to display Customer Maintenance "Email To Address" + "Email Cc Address" in separate columns instead of by "Email Type"

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All!

I've created a SmartList using the following to extract the "Email To Address" + "Email Cc Address" from Customer Maintenance Options (as shown below circled in black):

4721.1.PNG

SmartList created as follows:

Series: Sales

Table: RM Statement Email Address

So currently, the SmartList is displaying the email addresses (To+Cc). No problem with that.

I'm just wondering if it is possible to separate "Email To Address" & "Email Cc Address" into different columns instead of using Email Type (1 & 2) to differentiate between them (See Possible Example below).

3162.2.PNG

Possible Example:

Customer Number	Email To Recipient	Email Cc Recipient
AARONFIT0001	testToAddress	testCcAddress
ADAMPARK0001	test@yahoo.com
ADVANCED0001	test@gmail.com

Thanks in advance for any help given!

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Possible to display Customer Maintenance "Email To Address" + "Email Cc Address" in separate columns instead of by "Email Type"

Hello,

does anyone have a response to this? how to build this query in "Smartlist" to begin with? I have a similar issue trying to run a report that will spill out the email address from the customer maintenance options module