Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-04-2018, 02:45 PM
GregL GregL is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jun 2011
Posts: 6
GregL is on a distinguished road
Default Field for date that I run the mail merge; not Date nor CreateDate

I'm doing mail merge in MS Word 2016 to create letters that I mail out. The letters have a date on them representing the date I mail the letter.



Rather than update that date every time, I want a field to insert the current date when I run the mail merge. However, when I create a set of documents by running the mail merge, I don't want that date to update if I later open the document. I want the date to remain the date that I ran the mail merge.

If I use the "Date" field, it works fine when I run the mail merge but updates the date if I later open one of the files created by the mail merge.

If I use the "CreateDate" field, it shows the date the original document was created, not the date I ran the mail merge.

What can I do to get it to automatically give me the date that I run the mail merge, but not update it later if I open a file created by the mail merge?
Reply With Quote
  #2  
Old Yesterday, 03:57 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,622
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

One possibility would be to use a date field and split the merge with
http://www.gmayor.com/individual_merge_letters.htm. The resulting documents would have the date you ran the merge fixed.
OR
You could use a CREATEDATE field, SaveAs with the same name and update the field before running the merge,

__________________
Graham Mayor - MS MVP (Word)
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
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


All times are GMT -7. The time now is 01:11 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft