Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 01:33 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