Hi All,
I am having problems merging excel to word,the data merges all right and the dates are ok, the
problem is if a date column in excel is blank then in word '12:00:00AM' appears instead of a blank.
I have tried changing the cells from date format to text but that doesn't work.

any help will be appreciated.

Cheers

Try setting the correct date format in the (Word document) MergeField.

Check Word Help on the different arguments / flags for MergeFields.

Hi Van,

Thanks for your reply, I have tried setting the format, dosen't seem to work, but I'm not sure if I'm doing it right.

I have noticed however that the data source shows in the receipient address box as 12:00OOAM as well.


Cheers

Check Word Help topic "Date-Time Picture (\@) field switch"

Thank for the reply Van,

I have checked out the help on this and have set up the field switch,
but it changes the time 12:00:00AM to todays date.
How to I get it to be blank if this time is there

Insert New Field and use this function



Copy Then Edit > Paste Special Value

Do the mail Merge step by using the new field

thanks Nattasira

that did the trick

Cheers