Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2017, 10:40 AM
KDP KDP is offline Mail Merge Date Error Windows 10 Mail Merge Date Error Office 2016
Novice
Mail Merge Date Error
 
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 Mail Merge Date Error Windows 7 64bit Mail Merge Date Error Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-11-2017, 01:38 PM
KDP KDP is offline Mail Merge Date Error Windows 10 Mail Merge Date Error Office 2016
Novice
Mail Merge Date Error
 
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 Date Error 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
Mail Merge Date Error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft