How to add images to a table in Outlook based on a cell value

Tabatha Manley 0 Reputation points
2024-02-12T18:55:06.1666667+00:00

I've built a table in Excel that adds an image to each row of data based on the value of a cell. I want to copy the information from some of the columns into a table in Outlook such that I can keep links (no problem), insert only specific columns (no problem), and insert the images that are based on a cell value. When I copy/paste this column, only the alt text for the images is transferred. There are too many rows to manually add the images. Is there a way to bulk import these images from Excel into my Outlook table? (Copy/paste the table while keeping source formatting also does not work; it still replaces the images with the alt text.) Thanks for any assistance!

Outlook
Outlook
A family of Microsoft email and calendar products.
2,606 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,291 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yuki Sun-MSFT 40,016 Reputation points
    2024-02-13T03:28:16.88+00:00

    Hi @Tabatha Manley ,

    By "insert the images that are based on a cell value", do you mean the images in Excel are added using the IMAGE function as described in this blog? If so, I tried testing in my Office for Microsoft 365(Version2401) and the images can be added in Outlook properly through copy and paste:

    1. In Excel, select the column with images and press Ctrl+C to copy it.
      User's image
    2. In Outlook, place the cursor next to the existing table and press Ctrl+V to paste:

    User's image

    User's image Did I misunderstand anything here?

    If you have followed the same steps but it still doesn't work, personally I'd recommend trying to draft the table you want to include in the email directly in Excel, then copy the whole table to Outlook and check if it can help.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments