Date Calculations in Word Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noah Kaufman - 14 Oct 2006 06:10 GMT

Hi -

I'm putting together a mail merge document, and I want to be able to take
today's date, and add 20 days to it and have that date print in the final
document.

So for example, if today was October 13 - I would want to print a sentenance
like "Be sure to call us no later than October 23" (the "October 23" value
would be today's date, "October 13" plus 10 days).

I know that I can do an "Insert" -> "Field..." and that I can do a
calculation as part of the merge, but what would be the correct formula to
enter? It does not seem like it takes Excel-style formulas.

Thank you very much, in advance, for answering my question.

Sincerely,

Noah Kaufman
New World Design
Cambridge, Massachusetts, USA

Reply to this Message

Doug Robbins - Word MVP - 14 Oct 2006 06:18 GMT

See the magnus opus created by fellow Word MVP 'Macropod' that can be
downloaded from:

http://www.wopr.com/w3tfiles/10-365442-WordFieldMaths.zip

Signature

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

> Hi -
>
[quoted text clipped - 18 lines]
> New World Design
> Cambridge, Massachusetts, USA

Reply to this Message

Noah Kaufman - 14 Oct 2006 06:57 GMT

Hi Doug -

Thank you for the pointer to the document; it is quite extensive, but it
does not address how to do date related calculations.

So although I now know more than I did before, my basic question still
remains unanswered. How does one print the date that is "N" days in the
future? (See my previous post for an example.)

Sincerely,

Noah Kaufman
New World Design
Cambridge, Massachusetts, USA

Reply to this Message

Noah Kaufman - 14 Oct 2006 08:10 GMT

Thank you to everyone who replied. I've found my answer, and although it was
more complicated than I thought, and also required some "tweaking" -- it
works the way I want it to.

You can find the key piece on the web here:
http://addbalance.com/word/datefields2.htm

This guy has a field that was created by a macro that is complicated to say
the least. I did not bother with the macro, but instead downloaded his
sample document with the field, copy and pasted it into my target document --
and then edited the field to make it work.

Reply to this Message

Graham Mayor - 14 Oct 2006 12:32 GMT

There is an example in the link Doug posted which explains how to do what
you want. You simply have to use a little imagination to make it work with
your fields, by changing the delay to 10 and the fieldname from DATE to that
of your FIELD.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thank you to everyone who replied. I've found my answer, and
> although it was more complicated than I thought, and also required
[quoted text clipped - 7 lines]
> downloaded his sample document with the field, copy and pasted it
> into my target document -- and then edited the field to make it work.

Reply to this Message