View original (French)

Mail merge a date from Excel in Word

Solved
refpons Posted messages 4 Status Membre -  
 remibeauclair -
Hello,
I want to merge a date from an Excel table into a Word form. In the Excel table, the date column has a standard format because I also use this table for queries.
When I merge, the date loses its format: dd/mm/yyyy.
Can you help me?
Thank you.

Configuration: Windows / Chrome 42.0.2311.135

2 réponses

Réponse 1 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 146
 
Hello,

Create a new column that will serve as a merge field for the dates, replacing the current one. For example, your dates in Excel are in column A
adapt this formula

=TEXT(A1,"dd/mm/yyyy")

A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
5
refpons Posted messages 4 Status Membre
 
Thank you, Mike,
This solution is effective. It saves me from having to type the date.
Last year, I had another solution without adding a column. I would write a formula in the form that looked like "MERGEFIELD title column \@ dd/MM/yyyy". This year, I can't find the form formula because I overwritten it....
Best regards,
0
remibeauclair
 

The most effective solution, the least time-consuming, we don't think about it but on top of that it's disconcertingly easy, thank you, I had wasted a day with MERGEFIELD and I was going in circles and now, the solution came to me.

0