unable to change the format of time shown in mail merge

[Kim B.]

I have an excel data table that contains various information for travel that
I have planned for other individuals. In excel any fields I have shown with
time are shown for example as 1:15 PM but when this data gets merged into my
word document is shows as 1:15:00 PM. How can I eliminate the seconds?

 

[macropod]

Hi Kim,

You can do this by adding a picture switch to your mergefield.

To do this:
.. select the mergefield and press Shift-F9 to expose the field coding. It
should look something like
{MERGEFIELD MyTime}
where 'MyTime' is your mergefield's name.
.. delete anything currently appearing after your mergefield's name and add
'\@ "h:m am/pm"', so that your field looks like:
{MERGEFIELD MyTime \@ "h:m am/pm"}.
.. if you want the hours and minutes to display leading 0s, change 'h:m' to
'hh:mm'.
.. press F9 to update the field.
.. run your mailmerge.

Cheers

 

[Kim B.]

Thank you so much. That was very helpful.

Hi Kim,

You can do this by adding a picture switch to your mergefield.

To do this:
.. select the mergefield and press Shift-F9 to expose the field coding. It
should look something like
{MERGEFIELD MyTime}
where 'MyTime' is your mergefield's name.
.. delete anything currently appearing after your mergefield's name and add
'\@ "h:m am/pm"', so that your field looks like:
{MERGEFIELD MyTime \@ "h:m am/pm"}.
.. if you want the hours and minutes to display leading 0s, change 'h:m' to
'hh:mm'.
.. press F9 to update the field.
.. run your mailmerge.

Cheers

--
macropod
[MVP - Microsoft Word]

I have an excel data table that contains various information for travel that
I have planned for other individuals. In excel any fields I have shown with
time are shown for example as 1:15 PM but when this data gets merged into my
word document is shows as 1:15:00 PM. How can I eliminate the seconds?