Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kim B. Kim B. is offline
external usenet poster
 
Posts: 1
Default unable to change the format of time shown in mail merge

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default unable to change the format of time shown in mail merge

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]


"Kim B." Kim wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kim B. Kim B. is offline
external usenet poster
 
Posts: 2
Default unable to change the format of time shown in mail merge

Thank you so much. That was very helpful.

"macropod" wrote:

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]


"Kim B." Kim wrote in message
...
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?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change a mail merge to a new document ADJS Mailmerge 4 April 20th 06 04:02 PM
Format Fractions in Mail Merge. John McGhie [MVP - Word and Word Macintosh] Mailmerge 4 March 22nd 06 09:55 AM
How do I format date and time fields in a merge document? Suzanne at CW Mailmerge 1 February 2nd 06 07:54 AM
Help With Time Formats When Doing A Mail Merge PLEASE nylebella Mailmerge 3 March 18th 05 04:09 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 02:13 PM


All times are GMT +1. The time now is 04:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"