Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2018, 05:02 PM
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 2016
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, that worked, and it's so simple! Weird that the tome doesn't make it clear. They should change this:


To force DATE fields to convert to their results (ie so that they become static dates), reflecting the date on which the merge was performed, simply embed them in a QUOTE field coded along the lines of:

{QUOTE{DATE}}
To this:
To force DATE fields to convert to their results (ie so that they become static dates), reflecting the date on which the merge was performed, simply embed them in a QUOTE field by pressing Ctrl+F9 twice to get two nested pairs of field braces, and type QUOTE after the first brace and DATE after the 2nd brace, like this:

{QUOTE{DATE}}
Reply With Quote
  #2  
Old 12-19-2018, 05:19 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,375
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

Quote:
Originally Posted by GregL View Post
They should change this:
The 'they' in this case is me, and I'm not inclined to make that example inconsistent with the rest of the examples in the thread. The instructions in that example, if followed correctly, will produce the same result as the workaround I gave you.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-19-2018, 07:24 PM
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 2016
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

Interesting how it becomes uneditable, even in the original doc, after doing a merge. So if you want to just change the date formatting, you have to scrap it and start over. Or is there a way to make it go back into editable form?
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 10:33 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