Help in copy and paste table from excel to email

Hello @chandrashekar_padmin,

Kindly check this ans for passing the sender email address in the variable.

and for closing the excel you have to append the below code in .ps1 script
$UserWorkBook.close()

And It will be better if you can add all the email addresses in a single variable and then pass that in shell script.
The above link will help you to achieve that.

In case you need any help you can message me.

Thanks & Regards,
Lipika Porey.

1 Like