How can I change the date used with a Word mail merge?

Maggie November 7, 2011
Pinterest Stumbleupon Whatsapp

When using Excel or Access as the database for Word mail merge, when merged the date in Word is in MM:DD:YYY format. I have changed the Windows default, I have tried right click on the field code but to no avail. My students find this very frustrating!

Ads by Google

  1. Maggie
    November 8, 2011 at 12:25 am

    Many thanks for your help. I have not had a lot of success in the past with {MERGEFIElD StartDate@"dd/MM/yyy"}. I found that it works spasmodically. However through the links you gave me by forcing the connection portion of the merge to prompt the user for the file and type of connection ie Excel file and the DDE connection is just fabulous. Many thanks Maggie  

    • Anonymous
      November 8, 2011 at 9:33 am

      Thank you Maggie for your reply and glad that this problem was solved correctly.

    • Tina
      November 8, 2011 at 4:50 pm

      Thanks a lot for your feedback, Maggie!

  2. Anonymous
    November 7, 2011 at 9:22 am

    http://www.ehow.com/how_4619985_numbers-ms-word-mail-merge.html
    used the Altf9 and in the date field as follows:

    {MERGEFIElD StartDate@"dd/MM/yyy"}

    Where StartDate is the name of field, yours will be whatever you have named the field you are merging from.
    http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm

    Formatting Mail Merge fields
    http://office-watch.com/t/n.aspx?a=1545

    To format merged data, you must format the merge fields in the main document. Don't format the data in the data source, because its formatting isn't retained when you merge the data into the document.

    Do one of the following:
    ---Change text formatting
    ---Change capitalization
    ---Change other formatting by using field codes
    http://office.microsoft.com/en-us/word-help/format-merged-data-HP005187180.aspx

    Date-Time Picture (@) field switch
    http://office.microsoft.com/en-us/word-help/date-time-picture-field-switch-HP005186227.aspx?pid=CH061047321033