Word Merge Picture Directory

Word Merge Picture Directory

This is an option that uses the individual’s picture and allows you to add whatever fields you want that are included in the Picture Export. This is an option on the blue Toolbar under the cloud icon in the Export Excel section. This export includes the Image URL that is needed for adding the picture to a directory.

Note

TouchPoint has both a Picture Directory (using the Individual Photo) and a Family Picture Directory (using the Family Photo) as options on the blue Toolbar. These are one-click options that are very simple to produce. The only reason you would want to use the option described below would be if you want to add or remove fields or change the layout.

We plan to publish recipes for the existing Directories that are on the Toolbar so you will be able to customize those instead of using this mail merge. These recipes will be published in late 2017.

Caution

We have tried this on a Mac, and the pictures do not display properly in the Excel Pictures export. However, they will display on a PC.

Create a Picture Directory using Word Merge

Step 1

Find your target list of people that you want included in the directory. Then select the blue Toolbar > Cloud > Export Excel > Pictures.

Step 2

Open the spreadsheet from your downloads folder if it does not open automatically. The spreadsheet will contain the image URL for each person with a photo on their record in addition to the individual contact information.

Save as .xls and give it a name.

Step 3

Open Microsoft Word and start a Word/Mail Merge.

Step 4

The data source will be the xls file you saved in the step above. You can now insert any MergeFields into the document you want.

Continue below to insert the image and complete the merge.

Inserting the Image into the Mail Merge

This is a bit different than inserting other data.

Step 1

In the Word document, place the cursor where you want to position your image.

Step 2

On the Insert Menu (or the Ribbon on Word), choose Field (see QuickParts on Word 2010).

Step 3

Under FieldNames, select IncludePicture, and click ‘OK’.

Note

You may see a message something like Filename not specified. That’s OK. That’s normal for this process.

Step 4

Turn on the FieldCodes by pressing the Alt + F9 key combination. The Merge Field will change to be the codes that Microsoft uses internally like this: { INCLUDEPICTURE \*MERGEFORMAT }

Step 5

Place your cursor just to the right of INCLUDEPICTURE and insert a space.

Step 6

Now from the Mailings Menu, insert the MergeField ImageUrl.

Now it should look like { INCLUDEPICTURE { MERGEFIELD ImageUrl } \* MERGEFORMAT }

Step 7

Press Alt + F9 to turn off fieldcodes. You will either see the first picture or a red x with the text “The linked image cannot be displayed”. This is normal.

Complete the Word Merge

Step 1

Now choose to Complete the Merge or Finish & Merge to merge “To new document” or “Edit Individual Documents”.

Step 2

In the new document, press Ctrl + A to select all, and then press F9.

Your images will be downloaded into your document.

Tip

You will want to save this template so that you can use it with a different Excel file anytime you want a picture directory using this same format.

This is a sample directory created using the mail merge:

https://i.tpsdb.com/hope.1203290903.Sample-Individual.png


Latest Update

11/13/2020

Modify image link with secure protocol.