Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Need help with Field Codes | New Users | |||
Date problem with mail merge Word 2002 | Mailmerge |