Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2006

Tip: Looking for answers? Try searching our database.

unable to change the format of time shown in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kim B. - 14 Nov 2006 21:07 GMT
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 - 14 Nov 2006 22:00 GMT
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

Signature

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?
Kim B. - 14 Nov 2006 23:33 GMT
Thank you so much.  That was very helpful.

> Hi Kim,
>
[quoted text clipped - 22 lines]
> my
> > word document is shows as 1:15:00 PM.  How can I eliminate the seconds?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.