Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

date + 10 days inserted into merged document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ace - 24 Aug 2006 18:42 GMT
How can I insert a date 10 days in the future into a merged document in Word?
Doug Robbins - Word MVP - 24 Aug 2006 21:16 GMT
This is not that easy to do during the mailmerge operation.   The easiest
thing would be to move your data source into and Excel spreadsheet and use
Excel's ability to handle the data arithmetic and then use the Excel
spreadsheet as the datasource.

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

> How can I insert a date 10 days in the future into a merged document in
> Word?
Graham Mayor - 25 Aug 2006 06:35 GMT
As Doug says, this is not easy, but it can be done. Download the sample
document linked from
http://www.gmayor.com/insert_a_date_other_than_today.htm and modify the
field code changing DATE to Mergefield Datefieldname and the delay from 301
to 10.

The result will be something like

{QUOTE{SET Delay 10}{SET a{=INT((14-{MERGEFIELD FIELDNAME \@ M})/12)}}{SET
b{={MERGEFIELD FIELDNAME \@ yyyy}+4800-a}}{SET c{={MERGEFIELD FIELDNAME \@
M}+12*a-3}}{SET d{MERGEFIELD FIELDNAME \@ d}}{SET
jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}{SET
e{=INT((4*(jd+32044)+3)/146097)}}{SET f{=jd+32044-INT(146097*e/4)}}{SET
g{=INT((4*f+3)/1461)}}{SET h{=f-INT(1461*g/4)}}{SET
i{=INT((5*h+2)/153)}}{SET dd{=h-INT((153*i+2)/5)+1}}{SET
mm{=i+3-12*INT(i/10)}}{SET yy{=100*e+g-4800+INT(i/10)}}{=dd*10^6+mm*10^4+yy
\# "00'-'00'-'0000"} \@ "d MMMM yyyy"}

Credit to fellow MVP 'Macropod' for the work put into this.

Signature

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

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

> How can I insert a date 10 days in the future into a merged document
> in Word?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.