#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Thomas Thomas is offline
external usenet poster
 
Posts: 35
Default Mailmerge Date

I have a template I created & used in Word 2003. As the mailmerge template
generated a document it would insert the days date in the Createdate field.
At that point I could save the generated document and if I opened it on a
later date it would show the date I generated the document.

I have upgraded to Word 2007 and it no longer works. When I generate a
document now the date inserted is the date the template was created. I have
tested with Createdate, Printdate, Savedate and Date without being able to
achieve the desired results. I have also tried with the "Preserve Formatting
During Updates" checked and unchecked with no luck.

1). Can someone tell me what field I should use to generate a document and
insert todays date?
2). When I save and open this document on a later date, I want to see the
date it was generated?


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge Date

When you use the word "template" do you mean a document saved as a .dot,
..dotx or .dotm file from which you are creating a mail merge main document
by using FileNew?

Or, are you referring to the mail merge main document that has just been
saved as a .doc, docx or docm file.

If you use a CREATEDATE field in the former and you create the mail merge
main document by using FileNew and then select that file, that mail merge
main document and the documents created by executing the merge will contain
the date upon which the FileNew action was taken.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Thomas" wrote in message
...
I have a template I created & used in Word 2003. As the mailmerge template
generated a document it would insert the days date in the Createdate
field.
At that point I could save the generated document and if I opened it on a
later date it would show the date I generated the document.

I have upgraded to Word 2007 and it no longer works. When I generate a
document now the date inserted is the date the template was created. I
have
tested with Createdate, Printdate, Savedate and Date without being able to
achieve the desired results. I have also tried with the "Preserve
Formatting
During Updates" checked and unchecked with no luck.

1). Can someone tell me what field I should use to generate a document and
insert todays date?
2). When I save and open this document on a later date, I want to see the
date it was generated?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mailmerge Date

Hi Thomas,

The DATE field ordinarily survives the mailmerge process and remain active in the output document, which can be problematic, since
such fields update to the current date every time you open the document. Conversely, CREATEDATE fields from the mailmerge main
document reflect that document's creation date (not that of the mailmerge output).

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 an IF field coded along the lines of:
'{IF TRUE {DATE}}'

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"Thomas" wrote in message ...
I have a template I created & used in Word 2003. As the mailmerge template
generated a document it would insert the days date in the Createdate field.
At that point I could save the generated document and if I opened it on a
later date it would show the date I generated the document.

I have upgraded to Word 2007 and it no longer works. When I generate a
document now the date inserted is the date the template was created. I have
tested with Createdate, Printdate, Savedate and Date without being able to
achieve the desired results. I have also tried with the "Preserve Formatting
During Updates" checked and unchecked with no luck.

1). Can someone tell me what field I should use to generate a document and
insert todays date?
2). When I save and open this document on a later date, I want to see the
date it was generated?



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Thomas Thomas is offline
external usenet poster
 
Posts: 35
Default Mailmerge Date

Macropod:

Since every record will have a first name, should my fomula look like this:
{ IF «FirstName» "",{DATE \@ "MMMM d, yyyy" \* MERGEFORMAT}}


  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mailmerge Date

Hi Thomas,

You could do that, but there's no need to complicate things - and I'd get rid of the \* MERGEFORMAT switch too (it does nothing to
enhance the merge).

--
Cheers
macropod
[Microsoft MVP - Word]


"Thomas" wrote in message ...
Macropod:

Since every record will have a first name, should my fomula look like this:
{ IF «FirstName» "",{DATE \@ "MMMM d, yyyy" \* MERGEFORMAT}}





  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mailmerge Date

Hi Thomas,

An alternative field construction is:
{QUOTE{DATE \@ "MMMM d, yyyy"}}

--
Cheers
macropod
[Microsoft MVP - Word]


"Thomas" wrote in message ...
Macropod:

Since every record will have a first name, should my fomula look like this:
{ IF «FirstName» "",{DATE \@ "MMMM d, yyyy" \* MERGEFORMAT}}



  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Thomas Thomas is offline
external usenet poster
 
Posts: 35
Default Mailmerge Date

Doug:

I have a .doc I am opening, merging in table data and saving off as a new
..doc. The problem is I want the new.doc to have the date it was generated.
I keep getting one of 2 results. 1) I open new.doc and get the date the
template was created or 2) I open new.doc and get todays date.

How can I generate new.doc on tue 10/10/09 and get the tue 10/10/09 date
each time I open that specific new.doc.

"Doug Robbins - Word MVP" wrote:

When you use the word "template" do you mean a document saved as a .dot,
..dotx or .dotm file from which you are creating a mail merge main document
by using FileNew?

Or, are you referring to the mail merge main document that has just been
saved as a .doc, docx or docm file.

If you use a CREATEDATE field in the former and you create the mail merge
main document by using FileNew and then select that file, that mail merge
main document and the documents created by executing the merge will contain
the date upon which the FileNew action was taken.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Thomas" wrote in message
...
I have a template I created & used in Word 2003. As the mailmerge template
generated a document it would insert the days date in the Createdate
field.
At that point I could save the generated document and if I opened it on a
later date it would show the date I generated the document.

I have upgraded to Word 2007 and it no longer works. When I generate a
document now the date inserted is the date the template was created. I
have
tested with Createdate, Printdate, Savedate and Date without being able to
achieve the desired results. I have also tried with the "Preserve
Formatting
During Updates" checked and unchecked with no luck.

1). Can someone tell me what field I should use to generate a document and
insert todays date?
2). When I save and open this document on a later date, I want to see the
date it was generated?




  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge Date

Use the {IF TRUE {DATE}} construction suggested by Macropod in his initial
response to your original question.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Thomas" wrote in message
...
Doug:

I have a .doc I am opening, merging in table data and saving off as a new
.doc. The problem is I want the new.doc to have the date it was
generated.
I keep getting one of 2 results. 1) I open new.doc and get the date the
template was created or 2) I open new.doc and get todays date.

How can I generate new.doc on tue 10/10/09 and get the tue 10/10/09 date
each time I open that specific new.doc.

"Doug Robbins - Word MVP" wrote:

When you use the word "template" do you mean a document saved as a .dot,
..dotx or .dotm file from which you are creating a mail merge main
document
by using FileNew?

Or, are you referring to the mail merge main document that has just been
saved as a .doc, docx or docm file.

If you use a CREATEDATE field in the former and you create the mail merge
main document by using FileNew and then select that file, that mail
merge
main document and the documents created by executing the merge will
contain
the date upon which the FileNew action was taken.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Thomas" wrote in message
...
I have a template I created & used in Word 2003. As the mailmerge
template
generated a document it would insert the days date in the Createdate
field.
At that point I could save the generated document and if I opened it on
a
later date it would show the date I generated the document.

I have upgraded to Word 2007 and it no longer works. When I generate a
document now the date inserted is the date the template was created. I
have
tested with Createdate, Printdate, Savedate and Date without being able
to
achieve the desired results. I have also tried with the "Preserve
Formatting
During Updates" checked and unchecked with no luck.

1). Can someone tell me what field I should use to generate a document
and
insert todays date?
2). When I save and open this document on a later date, I want to see
the
date it was generated?





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date and Day issue in Mailmerge cjshaffer Mailmerge 2 June 18th 09 07:18 PM
date format in mailmerge cacuk Mailmerge 3 June 17th 09 09:13 PM
Mailmerge Date problem Anthony Viscomi Mailmerge 1 March 29th 07 05:23 PM
mailmerge date conversion tamee Mailmerge 4 March 19th 07 03:53 PM
date mailmerge problem Bob Bedford Mailmerge 5 March 17th 06 08:57 AM


All times are GMT +1. The time now is 03:43 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"