Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change a mail merge to a new document | Mailmerge | |||
Format Fractions in Mail Merge. | Mailmerge | |||
How do I format date and time fields in a merge document? | Mailmerge | |||
Help With Time Formats When Doing A Mail Merge PLEASE | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |