AnsweredAssumed Answered

List function and Paragraph returns

Question asked by bookalaka on May 26, 2018
Latest reply on May 27, 2018 by bigtom

Hello,

 

I have a script that copies items from a portal and places them in an email to send to clients. Have not been able to figure how to create a double spaced list with paragraph returns.  (When I copy and paste manually to my email works double spacing is perfect. However using the List function is not allowing returns should I be doing this differently?

 

Thanks for help

 

my list looks like this

 

After tasting this is a list of wines you wanted to remember. Special quantity pricing is not listed.

 

07 Boroli Barolo, D.O.C.G. (6 x 750ml) $ 165/$27.5 NET   88 Robert Parker 

11 Cleto Chiarli Lambrusco di Sorbara 'Vecchia Modena', D.O.C. Dry $138/$11.5 Family Plan $124.2/10.35   SILVER Decanter 

09 Ramey Wine Cellars Chardonnay Sonoma Coast  $312/$26 NET   92 Stephen Tanzer 

33 Chambers FROM THE LIBRARY $0/$0 NET

 

 

Will like to have Double Spacing

 

After tasting this is a list of wines you wanted to remember. Special quantity pricing is not listed.

 

07 Boroli Barolo, D.O.C.G. (6 x 750ml) $ 165/$27.5 NET   88 Robert Parker 

 

11 Cleto Chiarli Lambrusco di Sorbara 'Vecchia Modena', D.O.C. Dry $138/$11.5 Family Plan $124.2/10.35   SILVER Decanter 

 

09 Ramey Wine Cellars Chardonnay Sonoma Coast  $312/$26 NET   92 Stephen Tanzer 

 

33 Chambers FROM THE LIBRARY $0/$0 NET    

 

 

SCRIPT

 

Set Variable [ $EmailTo; Value:UCR::Email1 ]

Set Variable [ $Account; Value:UCR::AccountName ]

Set Variable [ $Customer_ID; Value:UCR::CUSTOMER_ID MATCH FIELD ]

Set Variable [ $UCR_ID; Value:UCR::UCR_ID ]

Perform Script [ “UCR_SelectALL_g_Verify” ]

Go to Layout [ “Prod_Select_UCR_Portal” (UCR) ]

Enter Find Mode [ Specified Find Requests: Find Records; Criteria: UCR::UCR_ID: “=” ] [ Restore ]

Set Field [ UCR::UCR_ID; $UCR_ID ]Perform Find [ ]
Loop

Set Variable [ $ItemPrice; Value:UCR_ITEMS::ItemLookUp ]Go to Portal Row

[ Select; Next; Exit after last ]Go to Portal Row

[ Select; Last ]End Loop

Copy All Records/Requests

Go to Layout [ “Email_Sent” (Email_Sent) ]

New Record/Request

Set Field [ Email_Sent::EmailSentTo; $EmailTo ]

Set Field [ Email_Sent::Customer_ID Match Field; $CUSTOMER_ID ]

Set Field [ Email_Sent::COMPANY; $Account ]

Paste [ Email_Sent::PasteResult ] [ Select ]

Commit Records/Requests

[ No dialog ]
Send Mail [ Send via E-mail Client; To: Email_Sent::EmailSentTo; Subject: "reWINEder_UCR"; Message: "After tasting this is a list of

wines you wanted to remember. Special quantity pricing is not listed.¶¶"& List (Email_Sent::PasteResult ) ]Go to Layout [ “UCR_Entry” (UCR) ]
Perform Script [ “UCR_gSelect_Clear” ]
Go to Object [ Object Name: "Universal" ]

 

   

Outcomes