Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-20-2022, 12:28 PM
samder68 samder68 is offline Merge Creates Doc When Field Blank but Contains Formula Mac OS X Merge Creates Doc When Field Blank but Contains Formula Office 2021
Novice
Merge Creates Doc When Field Blank but Contains Formula
 
Join Date: Oct 2022
Posts: 2
samder68 is on a distinguished road
Default

Thanks! You are correct, however, I couldn't solve the issue by excluding records with a space in that field because the field was contained within a text box. Mail merge rules don't function the same way for fields in headers, footers, text boxes, etc.

My workaround was to create a column header/merge field called Blank, write a similar formula with blanks and spaces, insert the field "Blank" into my document, NOT in a text box, and eliminate records with blank spaces.
=IF(ISBLANK(B3)," ","")

It was a weird set of circumstances, but this worked.

Thanks for your help. You brought me over the finish line.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Creates Doc When Field Blank but Contains Formula Page Break Creates Blank Page TheWriterBloke Word 2 09-06-2019 04:13 AM
Merge Creates Doc When Field Blank but Contains Formula Mail merge returning blank field SHA Mail Merge 3 05-03-2019 01:54 PM
Word 2010: Section Break "Next" Creates Blank Page Eri Word 11 02-09-2017 03:36 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Merge Creates Doc When Field Blank but Contains Formula How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:27 AM.


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