+ Post New Thread
Results 1 to 5 of 5
Office Software Thread, Auto replace date on mail merge in Technical; Hi guys, Our office lady is having some issues with Mail merge, when the data comes into MS word the ...
  1. #1

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    946
    Thank Post
    60
    Thanked 123 Times in 87 Posts
    Rep Power
    124

    Auto replace date on mail merge

    Hi guys,

    Our office lady is having some issues with Mail merge, when the data comes into MS word the date reverts to MM/dd/yyyy, US format. I have checked language settings in word and excel, dug about and changed the mail merge field properties - which broke it! And now I am getting peeved. Any ideas?

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    Where is the data coming from? Is that passing it it in US format?

  3. #3

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    946
    Thank Post
    60
    Thanked 123 Times in 87 Posts
    Rep Power
    124
    Quote Originally Posted by CESIL View Post
    Where is the data coming from? Is that passing it it in US format?
    I checked the Excel sheet formatting and it is all set to English UK, it was fine before she got married and we made a new account for her.

  4. #4
    VeryPC_Tom_M's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    388
    Thank Post
    14
    Thanked 82 Times in 79 Posts
    Rep Power
    45

  5. #5

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    946
    Thank Post
    60
    Thanked 123 Times in 87 Posts
    Rep Power
    124
    Yes, it didn't work either. Well, it sort of did. It put the correct date in but wouldn't merge more than the first line after that.

    I'll re-set her profile and hope that works.

SHARE:
+ Post New Thread

Similar Threads

  1. Mail Merging to PDF automatically send based on filename
    By wesleyw in forum How do you do....it?
    Replies: 2
    Last Post: 18th May 2011, 10:20 PM
  2. Mail merge and pictures
    By GrumbleDook in forum Educational Software
    Replies: 11
    Last Post: 4th February 2009, 11:13 AM
  3. Mail Merge Office 2003
    By karldenton in forum Windows
    Replies: 5
    Last Post: 18th June 2007, 08:26 AM
  4. Replies: 6
    Last Post: 28th September 2006, 07:06 PM
  5. Mail Merge with Office 2003
    By luke213 in forum Windows
    Replies: 1
    Last Post: 19th January 2006, 10:33 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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