![]() |
|
|
|
#1
|
||||
|
||||
|
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] |
|
#2
|
|||
|
|||
|
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? |
|
|
|
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 |
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 |