Microsoft Office Forums Mail Merge IncludePicture Empty Cell

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2019, 02:59 PM
lolla70 lolla70 is offline Mail Merge IncludePicture Empty Cell Windows 10 Mail Merge IncludePicture Empty Cell Office 2016
Novice
Mail Merge IncludePicture Empty Cell
 
Join Date: Mar 2019
Posts: 10
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
  #2  
Old 03-18-2019, 05:50 PM
macropod's Avatar
macropod macropod is offline Mail Merge IncludePicture Empty Cell Windows 7 64bit Mail Merge IncludePicture Empty Cell Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Try something along the lines of:
{IF{MERGFIELD image1}<> "" {INCLUDEPICTURE {MERGFIELD image1}}}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-19-2019, 05:17 AM
lolla70 lolla70 is offline Mail Merge IncludePicture Empty Cell Windows 10 Mail Merge IncludePicture Empty Cell Office 2016
Novice
Mail Merge IncludePicture Empty Cell
 
Join Date: Mar 2019
Posts: 10
lolla70 is on a distinguished road
Default

Great thanks it works.
Reply With Quote
Reply

Thread Tools
Display Modes


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 IncludePicture Empty Cell Mail merge: remove empty rows when a field is not showed Yarikh Mail Merge 4 09-23-2018 12:17 AM
Mail Merge IncludePicture Empty Cell 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


All times are GMT -7. The time now is 04:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft