Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Noah Kaufman Noah Kaufman is offline
external usenet poster
 
Posts: 3
Default Date Calculations in Word Mail Merge

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

  #2   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 Date Calculations in Word Mail Merge

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

http://www.wopr.com/w3tfiles/10-3654...FieldMaths.zip

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

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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Noah Kaufman Noah Kaufman is offline
external usenet poster
 
Posts: 3
Default Date Calculations in Word Mail Merge

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
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Noah Kaufman Noah Kaufman is offline
external usenet poster
 
Posts: 3
Default Date Calculations in Word Mail Merge

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 he
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.
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Date Calculations in Word Mail Merge

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.

--

Graham Mayor - Word MVP

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


Noah Kaufman wrote:
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 he
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Need help with Field Codes Rhino New Users 16 June 19th 06 06:06 AM
Date problem with mail merge Word 2002 Andy Davis Mailmerge 3 June 22nd 05 09:43 AM


All times are GMT +1. The time now is 03:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"