Mail Merging Dates Excel to Word Month and day wrong way.

That doesnt explain why if i open a new spreadsheet and a new word document and just do the whole same process the dates come out ok. Also that is all fine as far as i am aware.

I've tried that. The cell i put the formula in ends up with #VALUE

My date is in S5 so i've created a new column and put =DATEVALUE(S5)



I'm guessing thats an error?

I'll do that now... PS. How do i get a notification by email or whatnot when you have replied to this. Im just sat refreshing this page at the mo.

Just did that. It made 1 replacement and has made no difference on the merge! Losing the will to live with this!!! FML!

Genius!!!!!!!!! Thats flipped it. SO... what do i do now? Do i need to leave that extra column in??

I can do that no problem, but then as the excel document is a working document (as i keep adding to it daily), the dates i continue to add will surely end up with the same problem as previously as they havent been run through the formula?

Thanks for all your help. I'll probably pass on the Macro and just leave the extra column in and hide it, and just use that for the mail merge. Not the end of the day.

Thanks again!

Thank you, this code worked perfectly for me as well

Please Login or Register  to view this content.

I to had the issue of Word 2003 mail merge formating my date in US format rather than UK. So 2nd March 2012 was displayed as 3rd Febuary 2012. I pasted the code above into a new column of my Excel table and the mail merge worked perfectly.

In word i used {MERGEFIELD "Int_Date" \@ "DD MMMM YYYY"}

Wonderful thank you very much Excel forum.

God!, still didn't work for me. Is there any setting that i have to change?

02/06/2013 still became 06 February 2013.

I use word and excel 2003. I've tried to converted through DDE method, but still didn't work either

Hi, Please upload sample file in new thread for better understanding.

It's not working for me. I still have the same problem even though I used the proposed code. However, interesting thing is that I pull 3 columns and one of them is always working correctly and the other two are always wrong if the date CAN be misinterpreted. Meaning that 12.01. turns out as 1-dec and 13.01. as 13-jan... It's driving me mad !!

I stand corrected. It did work. I made new fields, then deleted them, and that didn't help either. I then deleted mergefields in word and added them again and all of the sudden it is working !? This is definitely a big bug.