Hi borntorun75,
I suspect the fault has something to do with the empty cell in F2. As a workaround, you could change the formatting in column F to 'dd-mmm-yyyy'. Alternatively, you might try changing the data connection method to DDE.
Also, FWIW, you could also replace the 'Date_Ending' IF test in your mailmerge main document with a mergefield coded as: {MERGEFIELD Date_Ending \@ "dd MMMM yyyy" \b "Item available until "}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|