Date calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheFoz - 30 Jan 2006 19:34 GMT

When using a Word form letter with mail merge is it possible to do
calculations with the date (today's date) value.
Today's date would appear in the heading area.
Then, I would like to have a date that is 14 days from the current date, any
date the form letter is utilized, printed in the body of the letter used in
the mailmerge.

Reply to this Message

Doug Robbins - Word MVP - 30 Jan 2006 21:38 GMT

You can use the DateAdd() function in a macro

Selection.InsertBefore Format(DateAdd("d", 20, Date), "MMMM d, yyyy")

Or, Macropod will probably come along and say:

To see how to do this and just about everything else you might want to do
with dates in Word, check out the topic 'Add Or Subtract Two Time Periods'
in my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

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

> When using a Word form letter with mail merge is it possible to do
> calculations with the date (today's date) value.
[quoted text clipped - 4 lines]
> in
> the mailmerge.

Reply to this Message

TheFoz - 31 Jan 2006 17:59 GMT

A big help. Thanks.

> You can use the DateAdd() function in a macro
>
[quoted text clipped - 15 lines]
> > in
> > the mailmerge.

Reply to this Message

Charles Kenyon - 31 Jan 2006 16:04 GMT

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> When using a Word form letter with mail merge is it possible to do
> calculations with the date (today's date) value.
[quoted text clipped - 4 lines]
> in
> the mailmerge.

Reply to this Message

TheFoz - 31 Jan 2006 17:59 GMT

Thanks for the help.

> This is more complex than you might imagine, but it can be done. See
> http://addbalance.com/word/datefields2.htm for information on the different
[quoted text clipped - 10 lines]
> > in
> > the mailmerge.

Reply to this Message

Rate this thread: