In this article let us discuss Sending email with attachment using Powershell and Send Grid. This includes the below steps (Also Available Github)


  • This can be used to send emails in Azure DevOps CI/CD Pipeline.
  • One of the important area is once your test is executed if you want to Send Test Report to respective stakeholders this will be very useful.
  • This will also answer the question of “How to send Email in Azure DevOps CI/CD Pipeline” 

Pre-Requisite: You need to have SendGrid Account (If you don’t have one create a Free Account)

Step 1: Register Sender in Send Grid
Step 2: Generate Send Grid API Key
Step 3: Create a Powershell function to send an email with attachment using SendGrid API
Step 4: Call the function using Powershell

Register Sender in SendGrid

Login to SendGrid account with your username and password 

(Note: If you do not have a SendGrid account create one using SendGrid SignUp)
Navigate to Settings > Sender Authentication

Click on Verify Single Sender

In a Create Sender Form, Enter all the mandatory details and Click on Create

Why do we need to add the Sender?

  1. Adding and verification of the sender is a must in SendGrid for security reasons.
  2. Without adding the sender, you will not be able to send the email to any person.
  3. The added sender email is used as From address in SendGrid API post request.
  4. Without adding the sender and verifying the sender, SendGrid will not allow you to send any emails.
  5. Important! Once you add the Sender, You will get an email to verify the Sender, you need to click on the Verify Sender link to complete the process of adding the sender.

Generating API Key in SendGrid

API Key is very important and mandatory if you are using SendGrid API to Send Emails

In order to Generate API Key, Go to Settings > Click on API Keys

Now, Click on Create API Key

Enter Your API Key Name, Choose Access and Click on Create and View

Once everything is done, You will see API Key

Important!: Copy the API Key and save Somewhere, If you lose this API key you can’t get it back.

Now we have successfully added the sender and generated the API key.

Next, We need to create a Powershell script to Call the API and Send an Email.

Powershell Script to Sending email with Attachment using SendGrid

In order to Send SendGrid Email, We need To Address, From Address, Subject, Body, APIToken, FileName, and FilePath and AttachementType.

Create a function with parameters

$ToAddress: This can be any address basically it is a recipient.

$FromAddress: This must be verified address (We have added in Step 2).

$Subject: Any string this will be shown as the subject line in the inbox

$Body : Body text if you want to write anything example “Please find attachment”

$APIKey: This is your API Key which is generated in the above step.

$FileName: Important! This can be any string. Specify file with extension, not File path
Note: This filename will be shown when the user receives the email.
Example: I am attaching 1.html but $FileName the value I am giving is SampleFile.html. So in this case even though you are attaching 1.html for the user it will be shown as SampleFile.html
Example : $FileName: myAttachement.html (Do not mention any path)

$FilePathWithName: This is the original File we want to add it as an attachment. This file will be converted to base64 attachment
Example: D://1.html

$AttachementType: This is the MIME type for attachment Refer: Mime Attachment Types.
Example: text/html (for Text or HTML file as an attachement)

Create a function body

Send Grid won’t allow you to send plain files as an attachment through SendGrid API. So In order to send any file as an attachment you need to create that into base64 format First.

Let us consider, We are sending the 1.html file as an attachment to SendGrid.

Using PowerShell we can covert .html file into base64 format.

In the above, the file is converted into base64 format and stored in the variable $EncodedFile.

Create SendGrid JSON Body

We need to create a send grid body object. Which will have information such as, to address, from address, body text, attachment, etc.

Create header for Sendgrid Email API

We are going to pass the API key in the header.

Invoke SendGrid API in your function 

Putting Everything Together. The Final Powershell Script

We have created Function Powershell Script which will Send the attachment but hold on we have not called this Function this. 

Call the above Function with Parameters.

Congrats! you have successfully sent an email.

Say how this article helped by mentioning on LinkedIn

Source link

Write A Comment