Word/ExcelMail Merge, only show dates on documents if a value is specified.

I've encountered a frustrating issue with my mail merge. Essentially, one of my fields is titled "next_letter_date" which will be populated from an Excel data source with the date we next intend to correspond with someone, where applicable.

In instances where no date needs to be added, my intention was to leave this field blank and my Excel formulae have been set-up to populate these cells with blank i.e, =""

Instead of blanks the fields are defaulting to today's date!

This is the last remaining issue for me to overcome before I an start merging so any assistance would be greatly appreciated (pulling my hair out at the moment).



PS - DDE Connection isn't an option here.

Hi Macropod,

Thank you for your reply, having tried both options, the first partially worked but the second replaced the date with 12:00:00am in instances where the cells were blank.

In the end I opted for a dirty workaround and added a hidden column to excel which converted the dates to text which appears to have resolved things.