View Single Post
  #7   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 VBA macro - Mailmerge date - for today and for history

The date will be the date upon which the mail merge main document is created
from the template by the use of FileNew. If however, you use FileOpen,
then yes, you will get the date upon which the template was created.

--
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

"Arden" wrote in message
...
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.


.