create date in mail merge documents in Word 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaykayIT - 30 Nov 2005 16:30 GMT

We previously used Access to create our Word documents from Templates and
inserting data from the access database. Now we are just using Word
documents and mailmerge using an Excel spreadsheet as the datasource.
However there is the problem of putting the date the document was created in
the newly merged document. If I use the Inserted Field {CREATEDATE} it puts
the date the main document was created into the merge document. This was not
a problem when using templates from Access but now it does not work with Word
Mailmerge. Any suggestions?

Reply to this Message

Charles Kenyon - 30 Nov 2005 17:58 GMT

Use a template with the CreateDate field. When you want to do a merge,
create a new document based on the template and merge that.

Signature

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://word.mvps.org/FAQs/ 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.

> We previously used Access to create our Word documents from Templates and
> inserting data from the access database. Now we are just using Word
[quoted text clipped - 8 lines]
> Word
> Mailmerge. Any suggestions?

Reply to this Message

kaykayIT - 30 Nov 2005 21:58 GMT

Thank you so much Charles. I have thought of that but if you have to open
and merge at least 7 merge documents at a time as oposed to having a wizard
in Access create all the documents, this extra step is cumbersome for the
secretaries. Is there some switch on the date field that will allow this?
or can it be done with VBA?

> Use a template with the CreateDate field. When you want to do a merge,
> create a new document based on the template and merge that.
[quoted text clipped - 10 lines]
> > Word
> > Mailmerge. Any suggestions?

Reply to this Message

Doug Robbins - Word MVP - 01 Dec 2005 04:59 GMT

How about having a field in the Excel datasource that contains the Now
function?

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

> Thank you so much Charles. I have thought of that but if you have to open
> and merge at least 7 merge documents at a time as oposed to having a
[quoted text clipped - 21 lines]
>> > Word
>> > Mailmerge. Any suggestions?

Reply to this Message

kaykayIT - 01 Dec 2005 15:35 GMT

Hello Doug and thanks for your suggestion. If I am not mistaken the Now
function will change the date everytime the document is calculated. If
Options Calculations is set to Automatic, there is a possibility that this
date can change. Possibility is even greater since there are a number of
users that use and update these documents frequently. We want a date that
will remain consistent. Wouldn't we have to copy this function into the new
row every time we create a new record?

> How about having a field in the Excel datasource that contains the Now
> function?
[quoted text clipped - 24 lines]
> >> > Word
> >> > Mailmerge. Any suggestions?

Reply to this Message