How to insert image in mail body from excel sheet

Help Something Else
1

i want to get excel sheet data and save it as image then i want that image in email body so can any help me on this please?

2

ChatGPT output:

In UiPath, you can use the “Excel Application Scope” activity to open an Excel workbook and read the data from a specific sheet, then use the “Save as Image” activity to save the sheet as an image, and finally use the “Send Outlook Mail Message” activity to send an email with the image in the body.

Here are the detailed steps:

  1. Use the “Excel Application Scope” activity to open the Excel workbook containing the sheet you want to read.
  2. Use the “Read Range” activity to read the data from the specific sheet and store it in a variable.
  3. Use the “Save As Image” activity to save the sheet data as an image and store the image in a variable.
  4. Use the “Send Outlook Mail Message” activity to create a new email and set the recipient, subject, and body of the email.
  5. Use the “Add Attachment” activity to add the image as an attachment to the email.
  6. Use the “Send” activity to send the email.

Alternatively, you can use the “Clipboard” activity to copy the sheet data and paste it as an image into the body of the email.

  1. Use the “Excel Application Scope” activity to open the Excel workbook containing the sheet you want to read.
  2. Use the “Read Range” activity to read the data from the specific sheet and store it in a variable.
  3. Use the “Save As Image” activity to save the sheet data as an image and store the image in the clipboard.
  4. Use the “Send Outlook Mail Message” activity to create a new email and set the recipient, subject, and body of the email.
  5. Use the “Paste from clipboard” activity to paste the image from the clipboard into the body of the email.
  6. Use the “Send” activity to send the email.

It’s important to note that when sending an email with an image, the size of the image will affect the size of the email. If the image is too large, it may not be able to be sent via email or may take a long time to send. You may need to optimize the image size before sending the email.

1 Like
3

@sathish_Kumar6

Follow the steps…

  1. Use save excel as pdf activity to convert excel as pdf
  2. Now use extract pdf as image activity (you need to downlod pdf activities) to convert the pdf as image
  3. Then for attachment …attach the image file in attachments and add img tag in your content or use hrml builder activity to insert image and construct the email body

Hope this helps

Cheers

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.