Mail Merge IncludePicture Empty Cell

lolla70 · #1 03-18-2019, 02:59 PM

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}}

macropod · #2 03-18-2019, 05:50 PM

Try something along the lines of:
{IF{MERGFIELD image1}<> "" {INCLUDEPICTURE {MERGFIELD image1}}}

lolla70 · #3 03-19-2019, 05:17 AM

Great thanks it works.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Legal Document Mail Merge - How do I automate the deletion of empty clauses	Octane1	Mail Merge	1	12-12-2018 03:48 PM
Mail merge: remove empty rows when a field is not showed	Yarikh	Mail Merge	4	09-23-2018 12:17 AM
creating badges using mail merge and do not want to supress lines with empty fields	johnmorabito	Mail Merge	1	04-25-2018 02:33 PM
Mail Merge Empty Data Field	Licos101	Mail Merge	2	04-10-2014 06:19 AM
INCLUDEPICTURE with Mail Merge - showing same image on every document	ccordner	Word	0	10-23-2013 06:42 AM