Forum Discussion

Mary Cross's avatar
Mary Cross
Copper Contributor
Oct 18, 2018

Problem with date formatting in mail merge

Hi I'm trying to pull a date mergefield through into a word document.  It has worked for me before so I can't work out what has changed.

The date on the excel spreadsheet is in short date format dd/MM/yyy

This is what i use in the word document, this was copied from MS help { MERGEFIELD Date-paid \@ "d MMMM yyyy" \*MERGEFORMAT } 

and it returns this 43391  In fact i just copied it from my word document to put it in here and that is what appeared. Even without the \*MERGEFORMAT it still doesn't work.

 

So i know it's kind of working because this seems to be the date come through but in 'general' format even though on the excel spreadsheet it is formatted as date.

 

Can anyone help please, this is most frustrating!

Thanks Mary 

excel
office 365

2 Replies

  • TomRioux78738's avatar
    TomRioux78738
    Copper Contributor
    Apr 14, 2020

    I create another column in Excel and use a formula like "=TEXT(A1,"D MMMM, YYYY")" then I insert that field into the Word document

  • Mary Cross's avatar
    Mary Cross
    Copper Contributor
    Oct 18, 2018
    Even weirder, there is another excel spreadsheet, part of the same workbook, identical layout. When i connect that one to my letter the date comes through fine. there is nothing different about the formatting in the same date column on each spreadsheet.

Resources