Merge Creates Doc When Field Blank but Contains Formula

samder68 · #1 10-19-2022, 07:19 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Page Break Creates Blank Page	TheWriterBloke	Word	2	09-06-2019 04:13 AM
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
How to ignore a mail merge field if the field is blank	redzan	Mail Merge	1	05-16-2013 08:34 AM