Field for date that I run the mail merge; not Date nor CreateDate

GregL · #8 12-19-2018, 05:02 PM

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}}

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