asked on Need Help setting up PowerShell script to send multiple emails
Greeting Experts,
I need help setting up and Powershell script to send multiple emails (to different users) listed in the spreadsheet. The script needs to pull different information from the spreadsheet and then put it into the subject line and body.. I have attached an example spreadsheet with headers and an email template to put into the script.. can somebody help me with this
ExampleSpreadsheet.csv
EmailTemplet.docx
I need help setting up and Powershell script to send multiple emails (to different users) listed in the spreadsheet. The script needs to pull different information from the spreadsheet and then put it into the subject line and body.. I have attached an example spreadsheet with headers and an email template to put into the script.. can somebody help me with this
ExampleSpreadsheet.csv
EmailTemplet.docx
Parmenter’s
Email Layout
TO: <Email Address> “From the ExampleSpreadsheet.xlsx”
From: Source email address (i.e. my email address to add later in the script)
No BBC
Subject: “Description in the Subject Line” (<Device Name>/<IP Address>) ““From the ExampleSpreadsheet.xlsx”
Body of Email
<Description of the Body Text>
Description
Device Name: <Device Name> “From the ExampleSpreadsheet.xlsx”
IP address: <IP Address> “From the ExampleSpreadsheet.xlsx”
URL Link: <URL Link > “From the ExampleSpreadsheet.xlsx”
Email Signature
Persons Name
Job Description
Street Address
City, State, and Zip Code
Phone
PowershellVB ScriptShell ScriptingScripting Languages
Last Comment
Mike
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
I could use the Microsoft Word mail merge functionality, but rather have a PowerShell script to the emails
ASKER
The Excel document has a list of identify information that is tied to the first column. Each row has different information that needs to go into the email. I don't think mail marge can do that.
that is how it works.. using the spreadsheet as a data source.
ASKER
Thanks