Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Kennett Square, Pennsylvania, USA
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mailmerge time (2003)

    I am attempting to mailmerge a simple excel list that has as one of its columns a 'time' entry (i.e, held in Excel as a date/time number and formatted as time -- 8:53 AM). When attempting to mail merge the time field into Word, the entry becomes 0.370139. The mergefield entry is {MERGEFIELD Time @"h:mm am/pm"}. The switch does not appear to be working. What am I doing wrong?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge time (2003)

    The switch should be preceded by a backslash:

    { MERGEFIELD "Time" @ "h:nn am/pm" }

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Kennett Square, Pennsylvania, USA
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mailmerge time (2003)

    I had one in there (but did not type it in the message). Word just wanted to display 0.3765...).

    I finally got it to work by using the suggestion of one of the other loungers to have Word 'confirm conversion at open' and to use DDE. I don't understand why representation of time is so difficult in a mail merge doc.

    Thanks for responding.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge time (2003)

    Microsoft seems to make mail merge a little less easy with each new version. No idea why.

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mailmerge time (2003)

    Hi Bill,

    <post#=249902>post 249902</post#> shows another way of converting decimal values for dates & times in a merge to 'real' dates & times, but Hans' solution is a lot less trouble.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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