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 / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Field Codes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard Lalande - 22 Sep 2007 18:28 GMT
I am working in a WORD 2002 document to where I have a field that populates
from an Access file.  The mergefield "EXPIRATION" is automatically populated
when I run the word document to which I want WORD to automatically add 10
years (date to destroy confidential documents).

Example:

I run the download letter from access with dumps the information in WORD
2002 pre-drafted letter but want WORD to automatically add 10 years to that
expiration field.

Expiration Date of September 2017.

WORD automatically add 10 Years

End Result: Destruction Date of September 2027
macropod - 22 Sep 2007 23:47 GMT
Hi Richard,

Use two fields, the:
. first coded as {MERGEFIELD EXPIRATION \@ MMMM}
. second coded as {={MERGEFIELD EXPIRATION \@ YYYY}+10}
where the field braces (ie '{ }') are created in pairs via Ctrl-F9.

Cheers
Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I am working in a WORD 2002 document to where I have a field that populates
> from an Access file.  The mergefield "EXPIRATION" is automatically populated
[quoted text clipped - 12 lines]
>
> End Result: Destruction Date of September 2027
 
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.