Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help!

gmayor · #1 08-31-2015, 09:32 PM

This presumably results from how you inserted the date, with a field that prompts for the date. Use a CreateDate field with a formatting switch instead. e.g. { CREATEDATE \@ "MM/dd/yyyy" } or wrap a Date field in a Quote field - { QUOTE { DATE } }
Either field will convert to text when merged.

macropod · #2 09-01-2015, 06:39 PM

Quote:

Originally Posted by gmayor

This presumably results from how you inserted the date, with a field that prompts for the date. Use a CreateDate field with a formatting switch instead. e.g. { CREATEDATE \@ "MM/dd/yyyy" } or wrap a Date field in a Quote field - { QUOTE { DATE } }
Either field will convert to text when merged.

A CREATEDATE field will output the date the mailmerge main document was created, not the date of the mailmerge. The { QUOTE { DATE } } construction will output the date of the mailmerge, but pop-ups would normally only come into consideration of the user wants a different date.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge - generating multiple letters	myspoonistoobig	Mail Merge	8	10-16-2015 12:03 AM
Mail Merge date not working	Dave1816uk	Mail Merge	4	03-05-2015 07:40 AM
Change Mail Merge Date Format from US to UK	Evanaught	Mail Merge	1	09-29-2013 08:02 PM
mail merge treating CITY as DATE	woody	Mail Merge	6	01-30-2013 03:22 PM
Date not transfering to mail merge correctly	tonywatsonmail	Mail Merge	1	07-01-2011 05:30 AM