Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 08-05-2016, 04:55 AM
utzja1 utzja1 is offline MERGE with IF field Windows 7 64bit MERGE with IF field Office 2013
Novice
MERGE with IF field
 
Join Date: Jun 2015
Posts: 11
utzja1 is on a distinguished road
Default

OK, I seem to have found a workaround that posts the blank jpg and eliminates the error message. I went into the merge source file and added the Blank.jpg file path as a merge field. It seems a little clumsy since every file will have it, but entering the path into the conditional field produced the "Filename not specified" error. Here's the syntax that finally worked:

{INCLUDEPICTURE {IF {MERGEFIELD PhotoPath1} <> "" {MERGEFIELD PhotoPath1} {MERGEFIELD PhotoBlank}}}

For whatever reason, if I don't use the PhotoBlank merge field and instead enter "Q:\\........\\Blank.jpg", I get the error message. When I hit Alt-F9 to show the fields, WORD has removed the quotation marks around the file path and thus the error. If you have a more elegant solution, I am more than willing to entertain it but I can work with this, I think. Your patience and willingness to help is greatly appreciated.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MERGE with IF field Merge Field Not Populating JennEx Mail Merge 8 03-31-2016 06:30 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
MERGE with IF field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.


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