+ Reply to Thread
Results 1 to 6 of 6

Date in word

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    87

    Date in word

    When creating a letter via mailmerge, for some reason the 'datecreated' merge doesn't work.
    Is there a way for the date to be put into the document template and not update automatically but will show the correct date it is made?

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Date in word

    Insert an ordinary DATE field, then select it, press Ctrl-F9 to embed it in another field, thus { 03/06/2014 } (or whatever other date format you're using) and edit it so you see {QUOTE 03/06/2014 }. Using the QUOTE field means the current date will be made static in the output documents.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    04-12-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Date in word

    Quote Originally Posted by macropod View Post
    Insert an ordinary DATE field, then select it, press Ctrl-F9 to embed it in another field, thus { 03/06/2014 } (or whatever other date format you're using) and edit it so you see {QUOTE 03/06/2014 }. Using the QUOTE field means the current date will be made static in the output documents.
    Thanks for your reply,
    So by using quite it picks up the day it was created?
    So if I was to put that into my template today, then create a document tomorrow it would show 04/06/2014?

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Date in word

    Quote Originally Posted by aaaaaaiden View Post
    Thanks for your reply,
    So by using quite it picks up the day it was created?
    There's no such thing as a quite field - I said a QUOTE field...
    So if I was to put that into my template today, then create a document tomorrow it would show 04/06/2014?
    That is what follows from I said. I note you refer to a template. Mailmerges should be run from mailmerge main documents, not from templates.

  5. #5
    Registered User
    Join Date
    04-12-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Date in word

    Quote Originally Posted by macropod View Post
    There's no such thing as a quite field - I said a QUOTE field...

    That is what follows from I said. I note you refer to a template. Mailmerges should be run from mailmerge main documents, not from templates.
    It was a typo! haha
    We have our company software that contains our letter templates. When creating a document the merge of the date created field doesn't work. Therefore I need a way for the date to insert upon the creation of the document from the template in the database.

    Does that make alittle more sense?

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Date in word

    Instead of asking/explaining the same thing over and over, how about trying it...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I need to autosave word template per date
    By abdulrahmanalakhrass in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 06:59 AM
  2. [SOLVED] How to delete a specific word in date.
    By adeelShah in forum Excel General
    Replies: 4
    Last Post: 01-24-2013, 08:37 AM
  3. Future date in Word
    By champs in forum Word Formatting & General
    Replies: 0
    Last Post: 03-07-2009, 04:44 AM
  4. Export Marked Data to Word by Date
    By BusTeacher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2008, 06:21 PM
  5. Help with date formating when export to Word
    By a0relento in forum Excel General
    Replies: 3
    Last Post: 10-15-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1