Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2018, 04:53 PM
macropod's Avatar
macropod macropod is offline Field for date that I run the mail merge; not Date nor CreateDate Windows 7 64bit Field for date that I run the mail merge; not Date nor CreateDate Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
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

See Convert Mailmerge Date Fields to Plain Text in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 12-19-2018, 10:27 AM
GregL GregL is offline Field for date that I run the mail merge; not Date nor CreateDate Windows 7 64bit Field for date that I run the mail merge; not Date nor CreateDate Office 2010 32bit
Novice
Field for date that I run the mail merge; not Date nor CreateDate
 
Join Date: Jun 2011
Posts: 12
GregL is on a distinguished road
Default

Thanks, it's great to know there is a way. But I don't understand to implement it.

I'm in Word 2016. I choose Insert tab > Text section > Quick Parts > Field, to get to the Field dialog.

In the list of codes I see both Date and Quote. If I choose Date and click Field Codes, the field code is populated with the word DATE. If I change that to QUOTE{DATE}, it returns nothing. If I do the same starting with QUOTE, same result. If I try {QUOTE{DATE}}, the OK button remains grayed out, so I can't return it.

If instead of selecting Date or Quote from the list I choose Formula, and enter the formula =QUOTE{DATE}, I get an error in the document when I return it. Same result with ={QUOTE{DATE}}.

In all cases, if I substitute parens for curly braces, that doesn't work either.

What am I missing?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Adding text before a date merge field AND fomatting date as well NikkiR Mail Merge 1 08-06-2014 07:18 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Field for date that I run the mail merge; not Date nor CreateDate Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Wrong date with CreateDate Blablub Word 0 02-18-2010 04:20 AM

Other Forums: Access Forums

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


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