View Single Post
  #6   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

The initial testing looks good, with the Quote/Date field actually coded as:
{QUOTE {DATE \@ "MMMM dd, yyy"} } to allow for the date formatting. The user
is confirming that her results are the same as our, both within the Main
document and through the VBA Template. We will confirm tomorrow that the
plain text date doesn't unexpectedly change before we modify across all of
our macros.

Thanks!

"Arden" wrote:

Macropod -

Thanks...I'll give this a try. It definitely seems like the direction we
want to go having today's date saved as the plain text.

Arden

"macropod" wrote:

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.


.