Link to home
Start Free TrialLog in
Avatar of Mike
MikeFlag for United States of America

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

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



Open in new window

ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike

ASKER

I could use the Microsoft Word mail merge functionality, but rather have a PowerShell script to the emails
Avatar of Mike

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.
Avatar of Mike

ASKER

Thanks