Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
My data source has the time formatted in this manner: 08.30.00 and I want it
to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
Try adding a
\@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
Does not work. 13.30.00 will print correctly as 13:30 but 08.30.00 prints 0:00
It's treating these values differently. -- Kim "Doug Robbins - Word MVP" wrote: Try adding a \@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kim wrote: Does not work. 13.30.00 will print correctly as 13:30 but 08.30.00 prints 0:00 It's treating these values differently. Try adding a \@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
My data source is a .txt file, it's generated from another application. I
tried all 3 DDE options available: Excel, Access, and Query, and none of them work -- Kim "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kim wrote: Does not work. 13.30.00 will print correctly as 13:30 but 08.30.00 prints 0:00 It's treating these values differently. Try adding a \@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
I cannot replicate your problem using
{ MERGEFIELD "Start" \@ "h:mm am/pm" } { MERGEFIELD "Start" \@ "h:mm am/pm" } and a tab delimited text file containing Start Finish 08:30:00 09:25:00 12:30:00 13:30:00 15:30:00 16:00:00 as the data source. The result for the first record is 8:30 AM 9:25 AM The connection to the datasource was the default method of connection. -- 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 "Kim" wrote in message ... My data source is a .txt file, it's generated from another application. I tried all 3 DDE options available: Excel, Access, and Query, and none of them work -- Kim "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kim wrote: Does not work. 13.30.00 will print correctly as 13:30 but 08.30.00 prints 0:00 It's treating these values differently. Try adding a \@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Time Fields
Post an offending sample of your data - like Doug I cannot reproduce the
fault on the basis of the information you have provided. DDE is for Excel/Access, TXT should not be an issue. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kim wrote: My data source is a .txt file, it's generated from another application. I tried all 3 DDE options available: Excel, Access, and Query, and none of them work From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button Word Options Advanced General Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Kim wrote: Does not work. 13.30.00 will print correctly as 13:30 but 08.30.00 prints 0:00 It's treating these values differently. Try adding a \@ "H:mm" switch inside the closing } of the mergefield that is displayed when you use Alt+F9 to toggle on the display of the field codes -- 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 "Kim" wrote in message ... My data source has the time formatted in this manner: 08.30.00 and I want it to print 8:30 am in Word yet it prints 12:00 am. If the time is 13.30.00, it will print fine: 1:30 pm. What is wrong? -- Kim |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging fields with more than 256 characters | Mailmerge | |||
Excel Date and Time not merging correctly to word | Mailmerge | |||
Blank date fields in Excel merging with Date/Time | Mailmerge | |||
linking documents together and mail merging at the same time | Mailmerge | |||
Word2000 Merging Fields | Microsoft Word Help |