Possible to provide line space in comments?

vino1493 · Post by **vino1493** » Wed Mar 28, 2018 2:40 pm

I'm trying to send to email notification using powershell. For the email's body I wish to add line space to look something like below
Hi All,

Load has completed.

My current code is

sSubject = ' load completed' ;
sBody = ' load completed';

# build powershell command
sPsCmd = '"& {
Send-MailMessage
-From ' | sFrom | '
-To ' | sTo | '
-cc ' | sCC | '
-Subject ' | '\"' | sSubject | '\"
-Body ' | '\"' | sBody | '\"
-SmtpServer ' | sSmtpServer | '
}"';

# execute command
ExecuteCommand ( 'powershell.exe -command ' | sPsCmd, 1 );

Is it possible to add line space to email's 'sBody' part?
Many space bars can be added as a workaround but this there a right way to do it?

Note:I didn't share few variable in the above code please ignore those

tm123 · Post by **tm123** » Wed Mar 28, 2018 2:52 pm

vino1493 wrote: ↑Wed Mar 28, 2018 2:40 pm I'm trying to send to email notification using powershell. For the email's body I wish to add line space to look something like below
Hi All,

Load has completed.

My current code is

sSubject = ' load completed' ;
sBody = ' load completed';

# build powershell command
sPsCmd = '"& {
Send-MailMessage
-From ' | sFrom | '
-To ' | sTo | '
-cc ' | sCC | '
-Subject ' | '\"' | sSubject | '\"
-Body ' | '\"' | sBody | '\"
-SmtpServer ' | sSmtpServer | '
}"';

# execute command
ExecuteCommand ( 'powershell.exe -command ' | sPsCmd, 1 );

Is it possible to add line space to email's 'sBody' part?
Many space bars can be added as a workaround but this there a right way to do it?

Note:I didn't share few variable in the above code please ignore those

You can add another option called BodyAsHtml, and then you can include HTML Tags on the Email Body

sPsCmd = '"& {
Send-MailMessage
-From ' | sFrom | '
-To ' | sTo | '
-Subject ' | '\"' | sSubject | '\"
-Body ' | '\"' | sBody | '\"
-BodyAsHtml -SmtpServer ' | sSmtpServer | '
}"';

vino1493 · Post by **vino1493** » Wed Mar 28, 2018 2:56 pm

Yeah that function will help, thank you so much for bringing it up.

vino1493 · Post by **vino1493** » Wed Mar 28, 2018 4:07 pm

Developed the below code and it is working as expected!

Code: Select all

  sSubject = 'WD-' | vDay | ' load completed ' ;
  sBody = '
	<body>
	  Hi All,
	  <br>
	  <br>
	</body>' | 'load started ';

# build powershell command
  sPsCmd = '"& {
  Send-MailMessage 
  -From ' | sFrom | ' 
  -To ' | sTo | ' 
  -cc ' | sCC | ' 
  -Subject ' | '\"' | sSubject | '\"
  -Body ' | '\"' | sBody | '\"
  -BodyAsHtml -SmtpServer ' | sSmtpServer | ' 
  }"';

# execute command
  ExecuteCommand ( 'powershell.exe -command ' | sPsCmd, 1 );

macsir · Post by **macsir** » Wed Mar 28, 2018 9:22 pm

I am using Powershell as well but I wrap the send email function to sendemail.ps1 file to accept parameters from TI processes.

Sophie Kay · Post by **Sophie Kay** » Thu Apr 05, 2018 8:16 am

Yeah, I was looking for an explanation, thanks)

TM1 Forum

Possible to provide line space in comments?

Possible to provide line space in comments?

Re: Possible to provide line space in comments?

Re: Possible to provide line space in comments?

Re: Possible to provide line space in comments?

Re: Possible to provide line space in comments?

Re: Possible to provide line space in comments?