Jun 12 2007, 05:34 AM
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.
Jun 12 2007, 09:28 AM
Try setting the correct date format in the (Word document) MergeField.
Check Word Help on the different arguments / flags for MergeFields.
Jun 13 2007, 08:05 AM
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.
Jun 13 2007, 09:33 AM
Check Word Help topic "Date-Time Picture (\@) field switch"
Jun 14 2007, 03:01 AM
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
Jun 14 2007, 03:05 AM
Insert New Field and use this function
Copy Then Edit > Paste Special Value
Do the mail Merge step by using the new field
Jun 14 2007, 05:54 AM
that did the trick
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here