Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2015, 06:39 PM
macropod's Avatar
macropod macropod is offline Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help! Windows 7 64bit Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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 gmayor View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 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