Thread
: [Solved]
Merge Creates Doc When Field Blank but Contains Formula
View Single Post
10-20-2022, 06:07 AM
macropod
Windows 10
Office 2016
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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]
macropod
View Public Profile
Find all posts by macropod