Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2022, 07:19 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 Merge Creates Doc When Field Blank but Contains Formula

This should be simple, but it's not.

I'm using Office on my Mac. Doing a simple mail merge using Excel as my data source. I have columns in the spreadsheet that contain formulas (if a cell is not blank, populate with x) that extend down 2000 rows.

Basically, if column B is not blank, columns, E & F will populate with the contents of E2 and F2.



When I go to do the mail merge, I'm getting 2000 documents instead of 6, I suspect because there are formulas in columns E and F.

I cannot for the life of me find how to NOT merge if the contents of column B are NULL.

Reply With Quote
  #2  
Old 10-20-2022, 06:07 AM
macropod's Avatar
macropod macropod is offline Merge Creates Doc When Field Blank but Contains Formula Windows 10 Merge Creates Doc When Field Blank but Contains Formula Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your formula doesn't leave the cells empty - it inserts a space into them. In any event, all you need do is apply a mailmerge filter to exclude records that have only a space in that field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #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
Reply

Thread Tools
Display Modes


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 12:02 AM.


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