I have a process flow that sends an email to a supervisor and it looks ugly. I am trying to add text and have list with returns after each record.

I am getting:

Shane Jones sjones@jbank.com John Smith jsmith@jbank.com Tom Edwards tedwards@jbank.com Phil Bensene pbensene@jbank.com Steve Grall sgrall@jbank.com

I want:

Shane Jones at - sjones@jbank.com
John Smith at - jsmith@jbank.com
Tom Edwards at - tedwards@jbank.com
Phil Bensene at - pbensene@jbank.com
Steve Grall at - sgrall@jbank.com

Is there a way to write the message builder query so that it will look like this with explanation text in the middle... The name and email is pulled from variables and the "at -" is just plain text?????

Thanks
Shane

What version of Processflow are you using, as there may have been an issue for your problem?

I'm at 8.0.3.6+ and it works just as you would like it to.

My msgbuilder is defined as follows using a simple query from EMPLOYEE to pull the first name, last name, and email address:

<!get1_FIRST_NAME> <!get_LAST_NAME> at <!get_EMAIL_ADDRESS> (cursor stays here, do not hit enter to add a CR/LF to bring the cursor to the next line or it add a blank line between each in the list)

The output in the email for this msgbuilder looks like the following:

ALEX CABANILLAS at acabanil@foxgal.com
MICHAEL THEDFORD at mthedfor@foxgal.com
ANN BROOKINS at abrookin@foxgal.com
BRENT BEARNSON at bbearnso@foxgal.com

I have my statement written just as you have it and I am getting everything as a paragraph. My guess is that this a version issue since I am on version 08.00.03.02.00 of ProcessFlow.

For now, I am going to enter the extra line between each one because it lists new hires and it usually would not have more than a couple on a page.

THANKS
Shane

I remember having that issue when I was on 8.0.2.9. I'm not sure which ESP level it is fixed in, but I'm positive it is after 8.0.3.2. Adding the CR/LF at the end should give you the extra line and at least make it a bit easier to read than before...