Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 12-11-2017, 01:27 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,358
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

That suggests most of your dates have been input as text, not as dates. Perhaps there is a space character before the date, for example.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-11-2017, 01:38 PM
KDP KDP is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 13
KDP is on a distinguished road
Default

@macfopod: for reason I dont know, but when i changed the header for the column the date merge worked.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Error mklindquist0815 Mail Merge 1 07-14-2017 08:36 PM
mail merge error in vba texas1014 Word VBA 2 03-08-2017 03:25 PM
vba error when trying to do a mail merge texas1014 Mail Merge 1 03-08-2017 03:23 PM
Date picker mail merge error. dan1 Mail Merge 7 06-28-2012 03:00 AM
Mail merge error? SRE Outlook 0 01-11-2010 05:54 PM


All times are GMT -7. The time now is 11:39 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft