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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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