Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I merge from Excel to Outlook I get a U.S. date format in Outlook. I have tried formatting the date and even pasting as text but each time Outlook shows it in U.S. format. How do I get the U.K. format to show as part of the merge?

    Neil
    Neil Eustice
    Woody Worshipper

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you mean that you perform a mail merge to e-mail in Word, with an Excel worksheet as data source?

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='794525' date='23-Sep-2009 10:46']Do you mean that you perform a mail merge to e-mail in Word, with an Excel worksheet as data source?[/quote]

    Ah...I think I found it...

    Date formatting in Excel is a property of the cell containing the date
    value, not a property of the data itself. To have it render the way you want
    it, right-click the date field in your Word main document & select Edit
    Field. Click the Field Codes button, then add the following mask at the end
    of the MERGEFIELD [field_name]:

    \@ "MMMM d, yyyy"

    After you OK out, hit the Update Labels button in the Mailings Tab> Write &
    Insert Fields group of Ribbon.


    Thanks
    Neil Eustice
    Woody Worshipper

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Yep, that's it (but you hadn't mentioned Word anywhere in your original question).

Posting Permissions

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