View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default VBA macro - Mailmerge date - for today and for history

Hi Arden,

In your mailmerge main document, simply embed the DATE field in a QUOTE field. To do this, select the date field, press Ctrl-F9 to
embed it in another field and type 'QUOTE' inside the left field brace. You should see something like:
{QUOTE1 December 2009}
Press F9 to update the field, then run your mailerge. The output document will now have today's date as plain text, rather than as a
DATE field.

--
Cheers
macropod
[Microsoft MVP - Word]


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