#1
|
|||
|
|||
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. |
|
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 |