Small and medium business | Business Central, N...

Format a list of text to be sent over email body

(0) Share

Report

Posted on by SammySevens

130

Hi BC Community,

I would like to email an entire POs lines to a user.

I can populate a list to include all lines, however, I can not figure out how to email this list using strsubstno.

The current issue is that even though I include the listdata variable into the StrSubstNo function, in AddBodyMessage that element is blank, and subsequent email text is blank.

My code below:

if userEmail <> '' then begin
    purchaseLine.SetRange(purchaseLine."Document Type", PurchaseHeader."Document Type");
    purchaseLine.SetRange(purchaseLine."Document No.", PurchaseHeader."No.");
    
    if purchaseLine.FindSet() then begin
        repeat
            listData.Add(purchaseLine.Description);
            counter := counter   1;
        until purchaseLine.next = 0;
        end;
    
    BodyMessage := 'Dear %1,
%2 has been fully approved.
Vendor:%3
Total($):%4
%5';
    subjectMessage := 'Your request %1 has been fully approved';
    AddBodyMessage := StrSubstNo(BodyMessage, userName, purchaseHeader."No.", purchaseHeader."Buy-from Vendor Name", purchaseHeader.Amount, listData.GetRange(1,listData.Count));
    addUserSubject := StrSubstNo(subjectMessage, purchaseHeader."No.");
    EmailMessage.Create(userEmail, addUserSubject, AddBodyMessage, true);

Thanks as always

All responses (3)

Answers (0)

SammySevens 130 on at

Like (0)

Report

RE: Format a list of text to be sent over email body

Yes am aware of this, and debugger indicates that listData[1][2][x...] elements are populated with a string.

So listData is not empty, but body message does not print out its contents, so I am also sure that is the source of the problem, but not sure how to remedy...
Suggested answer

AbhinavMehra 364 on at

Like (0)

Report

RE: Format a list of text to be sent over email body

Hi Sammy,

The listData variable is added to the email message using the GetRange method, but it's not clear how the listData variable is being populated. It's possible that the listData variable is empty.

you have to debugger to test value in Listdata variable first.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report
RE: Format a list of text to be sent over email body

Hi,

I doubt this function

listData.GetRange(1,listData.Count)

I dont think it returns and values you want. Can you check this?

Thanks