asked on Need Help setting up a script
Greeting Experts,
I need help creating a PowerShell script to read a list of Headers from an excel file and create an email for each one of those rows in an excel file and add it to a "canned" message in the email... example of the message:
Please open a ticket for the following location “<Frist Parameter> “ During the process of a security assessment, a device was found with one or more vulnerabilities. Please open a ticket and assign it to “<Secound Parameter> ”
Can Somebody help me with this... thank
I need help creating a PowerShell script to read a list of Headers from an excel file and create an email for each one of those rows in an excel file and add it to a "canned" message in the email... example of the message:
Please open a ticket for the following location “<Frist Parameter> “ During the process of a security assessment, a device was found with one or more vulnerabilities. Please open a ticket and assign it to “<Secound Parameter> ”
Can Somebody help me with this... thank
PowershellVB ScriptScripting Languages
Last Comment
Bill Prew
Do you have a sample of the Excel sheet? Makes it much easier to help.
ASKER
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
Looks like PSExcel got the job done for you, but just wanted to mention there is also another PS module called ImportExcel that also allows good read and write capability of Excel files. In case you are interested in taking a look, or it might be useful on future tasks you work on, here are a few links to get you started.
»bp
- dfinke/ImportExcel: PowerShell module to import/export Excel spreadsheets, without Excel
- PowerShell into Excel - ImportExcel Module Part 1 - Mikey Bronowski - Blog
- Reading and Writing Excel Files - powershell.one
»bp