Email Report Action - Prompted Email Address

Answered

Devin Frey

• November 21, 2016 15:10

Hey Community,

I've been configuring P&D in my live system, and loving every second of it so far.

A big question I had was in regards to the Email Report Action. Can you grab the Email Address based on User Input? What I mean by that is, can P&D prompt for the outbound email address, or even allow the user to change it on the fly--similar to how SAP's emailer works?

I haven't been able to find anything that seems to infer this.

Vote

1

• Official comment

  

  Thomas

  • November 22, 2016 10:17

  Hi Devin,

  Unfortunately not at this point, but you can set the e-mail address on a sales document UDF and then select it with SQL: -syntax in the report action.

  From the manual (which you can access by pressing F1 in the report action editor):

  Email Action

  The direct email field can be used to send the report to a fixed email specified in the configuration. Also it can be used to send to custom emails using dynamic syntax if needed. The direct email supports “SQL:” and “SQLMulti:” where SQLMulti: can be used to get multiple rows from a table.   Sample: if you on a sales order have defined a user-defined field (called U_MAIL) to hold an email, you could set up a direct email to $[ORDR.U_MAIL.0] in order to send the sales order to the email specified in the UDF.

   

Please sign in to leave a comment.