Answered

Trying to add a Carriage Return in Email Body

Like (0) Share

Report

Posted on 19 Aug 2022 18:53:25 by Madhatter071

Newbie here... I am trying to insert a carriage return in a hardcoded email, but the Char(13) is not working, I also tried Char(10), Split(), and , all to no avail. You can see in the code below where I am wanting the carriage return. Please help!

Office365Outlook.SendEmailV2(
LookUp('Project Data',Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, " & Char(13) & "On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". " & "The following reasons were listed to explain the raiting:" & Char(13) & ActualSelection.Text & Char(13) & "Please see photo's attached", {Importance: "High", Attachments: LoadImages}
);

Categories:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (2)

Madhatter071 10 on 19 Aug 2022 at 19:29:38

Like (1)

Report

Re: Trying to add a Carriage Return in Email Body

Yes, that worked!!
Verified answer

Pstork1 66,091 Most Valuable Professional on 19 Aug 2022 at 19:22:59

Like (1)

Report
Re: Trying to add a Carriage Return in Email Body

When you used the did you put it in quotes?

Office365Outlook.SendEmailV2( LookUp('Project Data',Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, " & "On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". " & "The following reasons were listed to explain the raiting: " & ActualSelection.Text & " " & "Please see photo's attached", {Importance: "High", Attachments: LoadImages} );
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 19 Aug 2022 at 19:20:36

Like (1)

Report
Re: Trying to add a Carriage Return in Email Body

@Madhatter071

Your formula should be:

Office365Outlook.SendEmailV2( LookUp('Project Data', Title = RREWInput.Selected.Result).'RREW Manager Email', "Load Quality Audit for " & ProjectInput.Selected.'Store Number' & " on " & Today(), "Hi Team, On" & Today() & " your load was audited for project " & ProjectInput.Selected.'Store Number' & ". Your load was rated as " & ConditionSelection.Selected.Result & ". The following reasons were listed to explain the raiting: " & ActualSelection.Text & " " & "Please see photo's attached", {Importance: "High", Attachments: LoadImages} );

Also by using the concat shortcut ($), you can change to:

Office365Outlook.SendEmailV2( LookUp('Project Data', Title = RREWInput.Selected.Result).'RREW Manager Email', $"Load Quality Audit for {ProjectInput.Selected.'Store Number'} on {Text(Today(), ShortDate)}", $"Hi Team, On {Text(Today(), ShortDate)} your load was audited for project {ProjectInput.Selected.'Store Number'}. Your load was rated as {ConditionSelection.Selected.Result}. The following reasons were listed to explain the raiting: {ActualSelection.Text} Please see photo's attached", {Importance: "High", Attachments: LoadImages} );

I hope this is helpful for you.