Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2016 date field will not format correctly in Word 2016 mail merge

    I have two date fields in an Excel 2016 spreadsheet that will merge only as the numeric date value (e.g. 43159 for 2/28/2018) regardless of the fact that the mergefield switches are set to format the info as mm/dd/yy.

    All other date fields in the spreadsheet display correctly in the merge doc. The date cells are all formatted exactly the same in Excel, and the mergefields are switch-formatted the same in the merge document. But for some reason, these particular cells will not display in the merge doc as dates.

    I have found a workaround by going to each problem date cell and inserting a ' before the date. This effectively makes it a text cell, and the mailmerge formatting will pick up the date and display it properly. This is highly impractical when the number of records is more than just a few.

    I cannot determine what is making these Excel data in these particular columns behave differently than the same data in another column. I can literally copy the good cell and paste into the problem cell - formats and all, and the merge doc still bungles the display of the date in the problem column.

    I have had this problem since I moved these spreadheets up to Office 2010. When I could use DDE, it was never a problem. But I cannot use DDE to get data from an .xlsx spreadsheet.

    Has anybody else had this problem? Or better yet, has anybody who has had this problem found a solution?

    Thanks,
    Alan

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    As discussed in the Word Mailmerge Tips & Tricks thread at the top of this forum (http://windowssecrets.com/forums/sho...ips-amp-Tricks) under the heading Mailmerge Data Format Problems, your problem is most likely caused by having mixed data types in your date column. The Mailmerge Data Format Problems topic also suggests some things you can do to remedy the issue.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Oct 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up Thanks. Good reference.

    Thank you for your help. I've been able to locate the spurious entries that were causing the problem. I appreciate the post.
    --
    Alan

Tags for this Thread

Posting Permissions

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