View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Arden Arden is offline
external usenet poster
 
Posts: 8
Default VBA macro - Mailmerge date - for today and for history

Doug -

Thanks for the counsel. I will re-test this. If I remember correctly from
last week's quick analysis, however, it was using the CREATEDATE of the
Template not necessarily the merged document.

Arden

"Doug Robbins - Word MVP" wrote:

Save the mail merge main document as a template and use a CREATEDATE field
for the date. When a document is created from the template, the date that
is displayed will be the date on which the document is created.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Arden" wrote in message
news
I am working with mailmerge documents which must print today's date in the
letter. A copy of the generated file also must be saved as an historic
archive of what was printed today, retaining the generated date even when
being viewed tomorrow.

I had started with Today and realized that it recalculates each time the
document is opened. No good.

So then I built the document with SAVEDATE and it seems to work as long as
I
manually run the merge from within the document.

The desired goal, however, is to use a VBA macro to run the merge and then
copy and store the generated file in a specific directory. Though the
SAVEDATE works within the manual merge process, the macro's execution of
the
merge generates a date before today...?

Any advice?

Thanks.


.