View Single Post
 
Old 05-19-2016, 01:39 PM
smitty777 smitty777 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: May 2016
Posts: 2
smitty777 is on a distinguished road
Default Mailmerge - when some records have photos, and some without

I am creating a company directory. Some people in the directory have photos on file, some do not.

In my directory template I have the line

{ INCLUDEPICTURE { MERGEFIELD "Image_URL" } }

where "Image_URL" is the column in my excel file that has links to profile photos. If no photo exists, the cell in this column in blank.

I run the merge, and CTRL+A and F9 to refresh, and I can see the pictures for everyone who has them. (YAY!)

BUT - for the people who don't have photos, I instead get "Error! Filename not specified." (BOO!)

MY QUESTION: How to I suppress that error message? Or replace it with generic text of some sort?

Thanks!!
Reply With Quote