I am sending an email from a UBAQ that is triggered from a BAQ Export. The Email Template is the following: [image] But when there is more than 1 line on the BAQ, the email is showing the following: [image] How do i get it so that is splits the information up into Seperate lines so that the Em…

Wondering what directive, criteria used? Have you already tried changing any options? If you’re going to be stuck with fields that return multiple, duplicate values I might try custom code to pull the first value(s) from the field(s), store in CallContextBPMData field(s) for use in the email? In…

Are those inserted fields “Table Queries” or “Field Queries”? And if “Field Query”, which boxes are checked? [image]

They are Field Queries and they are all ticked at the moment

I can never keep straight exactly how those boxes work, but I do believe that with multiple boxes checked, you can get multiple values. Try it with just one box checked. Then test to make sure the one selected is the one that produces the results.

I tried with just one ticked at a time but still get the same issue The email is showing correct information as my BAQ is just two records for now, it’s just the formatting to email is confusing to read, so I am just wanting to work out a way for it to just be separate lines within the email

Which BO and Method (and Pre or Post) is being used? You might be seeing the the “before” and “after” values. You see the same value because its another field that is actually being changed. If that field was in the < insert >, then you’de see that fields before and after values.

I think you want to insert a Table Query and select the columns to output. Then it will format a header row and multiple data rows.

I ended up having to use HTML to format a rather complex email from a BPM, coding a lot of stuff in variables before I got to the actual email. You may want to see if you can do something similar. Putting the data into tables can make it more legible.

Also, you can do HTML in a BPM’s Mail widget … [image] Keeping Line Breaks in Email ERP 10 Wow!! … Including the HTML framing (probably the wrong word) in the body of an email widget makes it HTML!! How come I am just learning this now!!! scream The “framing” required i…

BPM Email Formatting Issue

Epicor ERP 10

estm8ben (Ben Stohr) November 7, 2019, 4:13pm 10

I found this example to be helpful in coding my own emails that require lists of things:

https://www.epiusers.help/t/question-about-setting-a-variable-in-a-directive-to-use-as-the-to-in-an-email/39650

Topic		Replies	Views
BPM to Email Changes Epicor ERP 10 bpm	12	2787	December 18, 2022
Keeping Line Breaks in Email Epicor ERP 10 customization	17	7280	July 9, 2019
Advanced Print Routing - Email / Insert field formatting Epicor ERP 10 advanced-print-routi	24	6736	March 30, 2021
Data Directive Send Email Formatting Kinetic ERP epicor , bpm	16	2905	May 3, 2024
Sending an Email via BPM Epicor ERP 10 e10 , bpm	8	1528	March 8, 2024

BPM Email Formatting Issue

Related topics