Mail Merge: date in excel >> number in word!
Lucie
-
Cyr -
Cyr -
Hello,
My database is an Excel file. It contains dates.
When I transfer these dates to Word via mail merge, they turn into numbers: for example, 23/01/2015 becomes 42022.
My dates in Excel are correctly formatted as dates.
Can someone help me?
Thank you very much.
My database is an Excel file. It contains dates.
When I transfer these dates to Word via mail merge, they turn into numbers: for example, 23/01/2015 becomes 42022.
My dates in Excel are correctly formatted as dates.
Can someone help me?
Thank you very much.
1 réponse
Hello Lucie,
you have at least 2 possibilities:
1. Modify the field code in your Word document: press ALT F9 to display the codes. Complete the date code as follows with the bold switch below:
{ MERGEFIELD "your date field" \@ "dd MMMM yyyy" }, press ALT F9 again to hide the code and do a test.
2. Use the DDE exchange protocol with Excel: in your Word document, go to "File", "Word Options", "Advanced Options" (on the left), check the box "Confirm file format conversion on open" at the very bottom in the "General" section. Re-establish your link.
When you do the merge, choose the protocol "Excel worksheets via DDE".
Note that in your Excel workbook, the sheet containing the data must be in the first position if you have multiple sheets.
C-Claire
you have at least 2 possibilities:
1. Modify the field code in your Word document: press ALT F9 to display the codes. Complete the date code as follows with the bold switch below:
{ MERGEFIELD "your date field" \@ "dd MMMM yyyy" }, press ALT F9 again to hide the code and do a test.
2. Use the DDE exchange protocol with Excel: in your Word document, go to "File", "Word Options", "Advanced Options" (on the left), check the box "Confirm file format conversion on open" at the very bottom in the "General" section. Re-establish your link.
When you do the merge, choose the protocol "Excel worksheets via DDE".
Note that in your Excel workbook, the sheet containing the data must be in the first position if you have multiple sheets.
C-Claire
Hello, I used the DDE exchange protocol, it works. Thank you for your help.
Thanks a lot for this reply!!! The DDE exchange protocol is working!
Hello, if I open the Word file without the linked Excel file, the date is in the right format; however, if I open the Excel file first, the date is replaced by a number. Can you help me? Thank you.