Time format in Mail Merge field

[Look2TheSky2]

I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

 

[Dawn Crosier, Word MVP]

Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.

I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date: 9/26/2007 12:12 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

 

[macropod]

Hi,

Try:
{MERGEFIELD "Start_Time" \@ "h:mm AM/PM"}.

Cheers

 

[Doug Robbins - Word MVP]

Thanks, Dawn.

I have been looking for a name to call { } and Googling for French Brace
does turn a few (only a few mind you) hits that support the use of that
term.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[macropod]

Hi Doug,

Mostly I think you'll find they're just called braces.

Cheers

 

[Graham Mayor]

Or with relation to merge, field boundaries or brackets.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Dawn Crosier, Word MVP]

Hi Doug -

I don't remember when I learned the term ~ it's been a long time ago.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date:
9/27/2007 11:06 AM

 

[Look2TheSky2]

Works like a charm!!! Thank you everyone!

Hi,

Try:
{MERGEFIELD "Start_Time" \@ "h:mm AM/PM"}.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.