Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
create date in mail merge documents in Word 2000
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
create date in mail merge documents in Word 2000
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. -- 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. "kaykayIT" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
create date in mail merge documents in Word 2000
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? "Charles Kenyon" wrote: 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. -- 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. "kaykayIT" wrote in message ... 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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
create date in mail merge documents in Word 2000
How about having a field in the Excel datasource that contains the Now
function? -- 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 "kaykayIT" wrote in message ... 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? "Charles Kenyon" wrote: 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. -- 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. "kaykayIT" wrote in message ... 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? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
create date in mail merge documents in Word 2000
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? "Doug Robbins - Word MVP" wrote: How about having a field in the Excel datasource that contains the Now function? -- 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 "kaykayIT" wrote in message ... 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? "Charles Kenyon" wrote: 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. -- 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. "kaykayIT" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The WordPerfect "Reveal Codes" method is so much easier to use. | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help |