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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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