Thread: [Solved] Mail Merge Date Error
View Single Post
 
Old 12-11-2017, 10:40 AM
KDP KDP is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 13
KDP is on a distinguished road
Default Mail Merge Date Error

Hello,

I have a mail merge document which pulls multiple dates. The mail merge formula is: MERGEFIELD Vest_Date_1\@ "MMMM dd, yyyy"

First three dates comes out in correct format January 01, 2017, however the other dates pulls as random number. What I am doing wrong?

My data runs up to Vest_Date_25, meaning I have 25 Dates and only first 3 dates are coming in right format. Excel data is currently set to date "01/01/2017.

Please help me, I need to send these letters out today.
Reply With Quote