Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2015, 08:11 AM
MSFlowers MSFlowers is offline Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help! Windows 10 Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help! Office 2010 64bit
Novice
Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help!
 
Join Date: Aug 2015
Posts: 1
MSFlowers is on a distinguished road
Unhappy Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help!


I'm sure I'm just overlooking something completely simple on this really easy mail merge. I'm merging 12000 names and addresses into a letter going out at work and it all works beautifully until I click finish merge and it pops up prompting me to enter the date. So I do. And it merges one letter then prompts me for the next...so I'd have to do this on all 12000. HELP! What do I need to do? I already changed to a letter form that inclues a 'choose the date' macro and it didn't help.
Reply With Quote
  #2  
Old 08-31-2015, 07:12 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: 21,956
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

Since mailmerge, per se, has no 'add date' pop-up, I can only conclude you're using something that's non-standard. Without knowing what that is, it's impossible to give any particular advice.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-31-2015, 09:32 PM
gmayor's Avatar
gmayor gmayor 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
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
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: 21,956
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
  #5  
Old 09-01-2015, 09:37 PM
gmayor's Avatar
gmayor gmayor 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
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Hi Paul - Good point about CREATEDATE, it would only work on the day the merge document was created, or if the merge document was stored as a template and new documents were created from it.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft