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.