Sign in
    Shared Email Templates

    Insert pictures from datasets into Outlook emails

    If you often use the same pictures in your Outlook emails, you can create a simple dataset with a picture column and link it to your shared email templates. This will let you insert pictures from the dataset either automatically or by choosing which picture to insert from a dropdown list. You can also insert pictures into tables and lists.

    Add a picture column to a dataset #

    1. In Shared Email Templates, start creating or editing a simple dataset.

    2. Click the dropdown arrow next to the rightmost column.

    3. From the dropdown menu, select Picture.

      Add a picture column to a simple dataset.
    4. Enter the name of the column.

    5. Click a cell. Then click the ellipsis (…) menu in it and select what you want to insert: a link to a single OneDrive or SharePoint picture or links to multiple OneDrive or SharePoint pictures.

      Select an option from the ellipsis menu.
    6. Select the necessary file(s).

    7. When your dataset is ready, select the Save button.

    Insert pictures automatically #

    1. In your template, place the cursor where an image from a dataset is needed.

    2. On the template editor toolbar, select the The Insert picture button Insert picture button.

    3. Select Insert picture from dataset.

    4. The Insert picture dialog appears.

      • On the General tab:

        • Select your dataset.
        • Select the picture column.
        • Select the key value to identify the row that contains the image you need.
        The General tab in the Insert picture dialog
      • On the Picture tab, you can resize the image and add a link to it if needed.

      When you’re finished, select OK.

    5. Save the template.

    When you use this template, the add-in will automatically insert the specified picture into your email.

    A shared template inserted into an Outlook email with an image from a dataset

    Choose a picture to insert using a dialog #

    1. Start creating or editing a template. Place the cursor where you want an image from your dataset to appear.

    2. On the template editor toolbar, select the The Insert macro button Insert macro button.

    3. Select What to enter (WTE).

    4. The What to enter dialog appears.

      • On the General tab:

        • Select Dataset.
        • Enter the field name (you’ll see it as a prompt when inserting the template into an email).
        • Select your dataset.
        • Select the picture column.
        • Select the Insert picture checkbox, otherwise only the file name will be inserted.
        The General tab in the What to enter dialog
      • On the Picture tab, you can change the size of the image and add a link if you want to.

      When you’re finished, select OK.

    5. To save the changes, select Save.

    When you insert the template into an email, a dialog appears. It contains a dropdown list of dataset key values. Select the value that identifies the row with the picture you want to insert. Then select OK.

    Selecting an image through a dialog

    The template will be inserted with the image you selected.

    A shared template inserted into an Outlook email with an image selected from a dialog

    Insert pictures in tables and lists #

    If you want to include images in tables and lists in your emails, add a table or a list to your template and bind it to the dataset that contains the images you need. For detailed instructions, see How to auto-fill tables with dataset values and How to auto-fill lists with dataset values.

    See also #