Mail merge Word/Excel
Solved
Marion
-
C-Claire Posted messages 4562 Registration date Status Member Last intervention -
C-Claire Posted messages 4562 Registration date Status Member Last intervention -
Hello,
I created a mail merge list in Excel with a "date" column in the "long date" format (for example: Friday, May 13, 2015).
However, when I perform my mail merge in Word, this merge field does whatever it wants and displays: "12:00:00 AM"... A time, which has nothing to do with what I want... Are there any settings to adjust in Word? In Excel?
Thank you in advance!
I created a mail merge list in Excel with a "date" column in the "long date" format (for example: Friday, May 13, 2015).
However, when I perform my mail merge in Word, this merge field does whatever it wants and displays: "12:00:00 AM"... A time, which has nothing to do with what I want... Are there any settings to adjust in Word? In Excel?
Thank you in advance!
1 answer
-
Hello,
this date/time conversion issue during a Word-Excel mail merge keeps coming up on the forum.
Take a look here:
https://forums.commentcamarche.net/forum/affich-31545128-publipostage-word-excel
Adapt the format \@ "dd/MM/yyyy" to the one you want, namely \@ "dddd dd MMMM yyyy"
Pay attention to uppercase and lowercase letters.
--
C-Claire