Currently I am able to past a cell from MS excel into the word document. The
cell will not update when you open the document.

What does your statement have to do with your question that you used as
your subject?

To answer your subject, you could:
this macro:
Sub PrintTommorrowsDate()
Selection.InsertAfter (Date + 1)
ActiveDocument.PrintOut
End Sub

Works in the original document. When you use mailmerge it keeps the
information that was saved and does not update the field.

"Greg" wrote:

What does your statement have to do with your question that you used as
your subject?

To answer your subject, you could:
this macro:
Sub PrintTommorrowsDate()
Selection.InsertAfter (Date + 1)
ActiveDocument.PrintOut
End Sub

If you want a field, 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.

Using a Fill-In field to ask for the date might be easier.
--
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://www.mvps.org/word 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.

"murph" wrote in message
...
Works in the original document. When you use mailmerge it keeps the
information that was saved and does not update the field.

"Greg" wrote:

What does your statement have to do with your question that you used as
your subject?

To answer your subject, you could:
this macro:
Sub PrintTommorrowsDate()
Selection.InsertAfter (Date + 1)
ActiveDocument.PrintOut
End Sub

Using a fill in "Ask" field for the date was the easier solution that solved
the date issue.

"Charles Kenyon" wrote:

If you want a field, 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.

Using a Fill-In field to ask for the date might be easier.
--
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://www.mvps.org/word 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.

"murph" wrote in message
...
Works in the original document. When you use mailmerge it keeps the
information that was saved and does not update the field.

"Greg" wrote:

What does your statement have to do with your question that you used as
your subject?

To answer your subject, you could:
this macro:
Sub PrintTommorrowsDate()
Selection.InsertAfter (Date + 1)
ActiveDocument.PrintOut
End Sub

it is a good answer ,


"Greg" wrote in message
oups.com...
What does your statement have to do with your question that you used as
your subject?

To answer your subject, you could:
this macro:
Sub PrintTommorrowsDate()
Selection.InsertAfter (Date + 1)
ActiveDocument.PrintOut
End Sub