Thread: [Solved] Mail Merge IncludePicture Empty Cell
View Single Post
 
Old 03-18-2019, 02:59 PM
lolla70 lolla70 is offline Windows 10 Office 2016
Novice
  
Join Date: Mar 2019
Posts: 14
lolla70 is on a distinguished road
Default Mail Merge IncludePicture Empty Cell
I have in my excel sheet records that is like that

Project # Project Name image1 image2
1 Test1 c:\\document\\image1.jpg c:\\document\\image2
2 Test2 c:\\document\\image1.jpg

I want a formula that if there is no image in the cell like project #2 has no image 2 in the cell and it is blank and I don't want to show that. Right now I am getting the x the link is image cannot be displayed.

{INCLUDEPICTURE "{MERGFIELD image1}}
{INCLUDEPICTURE "{MERGFIELD image2}}
Last edited by lolla70; 03-19-2019 at 05:26 AM.
Reply With Quote