Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Display time in correct format in a mail merge
I'm creating a mail merge using an Excel worksheet as the source file and the
letter is in Word. One of the items in the worksheet is a date field formatted as HH:MM AM(PM). When the data is merged, it displays as HH:MM:SS AM(PM). How can I get the merge to display in HH:MM AM(PM) format? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Display time in correct format in a mail merge
In your Word document, try Alt-F9 to reveal the field codes and modify, e.g.
{ MERGEFIELD mydatefield } to look like { MERGEFIELD mydatefield \@"hh:mm am/pm" } (If there are other "switches" such as \*Mergeformat, leave them) Peter Jamieson "mleisure" wrote in message ... I'm creating a mail merge using an Excel worksheet as the source file and the letter is in Word. One of the items in the worksheet is a date field formatted as HH:MM AM(PM). When the data is merged, it displays as HH:MM:SS AM(PM). How can I get the merge to display in HH:MM AM(PM) format? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Display time in correct format in a mail merge
Thank you!
"Peter Jamieson" wrote: In your Word document, try Alt-F9 to reveal the field codes and modify, e.g. { MERGEFIELD mydatefield } to look like { MERGEFIELD mydatefield \@"hh:mm am/pm" } (If there are other "switches" such as \*Mergeformat, leave them) Peter Jamieson "mleisure" wrote in message ... I'm creating a mail merge using an Excel worksheet as the source file and the letter is in Word. One of the items in the worksheet is a date field formatted as HH:MM AM(PM). When the data is merged, it displays as HH:MM:SS AM(PM). How can I get the merge to display in HH:MM AM(PM) format? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
How do I format date and time fields in a merge document? | Mailmerge | |||
Mail Merge will only display contacts personal folder | Mailmerge | |||
Help With Time Formats When Doing A Mail Merge PLEASE | Mailmerge |