Mail Merge IncludePicture Empty Cell

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail Merge IncludePicture Empty Cell

FAQ

Thread Tools

Display Modes

03-18-2019, 02:59 PM

lolla70

Windows 10 Mail Merge IncludePicture Empty Cell

Office 2016

Novice

Join Date: Mar 2019

Posts: 14

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.

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