Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MaxArk[_11_] MaxArk[_11_] is offline
external usenet poster
 
Posts: 1
Default Improperly Displayed MergeField Format


I have a mail merge directory document which users data from an Excel
workshet as it's source. The datasource is volatile based on different
criteria.

One of the fields is time. Sometimes, in the merged report, the times
are displayed as a decimal number. What is odd thought, the same
report, with different data, will display the time properly. It is not
a repeated problem from one report to the next.

The Excel cells holding the data are formatted in time format. The
merge field in the merge document is also formatted ... {MERGEFIELD
"Timedr5" \@ "h:mm AM/PM"}

Where should I be looking to find the source of this problem?




--
MaxArk
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Improperly Displayed MergeField Format

How is the time entered in the data source. If it is in the format of h:m:s
or some variation thereof, that switch should work. Not however it will not
work for all times if the time is entered in the data source as h.m.s

Here is a probably explanation of why the latter format will not work that
was posted by Rich/rerat at the final post to the thread "Merging Time
Fields" that was posted by Kim on May 23:

I believe your data/values are being read like this:
08.30.00 = August 30, 2000 or just August 30 at midnight or 00:00:00 hrs
Because the "08" can represent the month of August
13.30.00 = 13:30:00
Since there is no 13th month, the "13" (or higher figure), will reflect the
24/military time correctly.


--
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

"MaxArk" wrote in message
...

I have a mail merge directory document which users data from an Excel
workshet as it's source. The datasource is volatile based on different
criteria.

One of the fields is time. Sometimes, in the merged report, the times
are displayed as a decimal number. What is odd thought, the same
report, with different data, will display the time properly. It is not
a repeated problem from one report to the next.

The Excel cells holding the data are formatted in time format. The
merge field in the merge document is also formatted ... {MERGEFIELD
"Timedr5" \@ "h:mm AM/PM"}

Where should I be looking to find the source of this problem?




--
MaxArk



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge data displays improperly Mikey Mailmerge 1 March 19th 07 10:21 PM
mergefield time format switch ignored Pauline Evans Mailmerge 7 March 28th 06 06:19 PM
Format Mergefield Decimal Values malycom Microsoft Word Help 4 February 21st 06 04:39 PM
Format true/false mergefield Gary O Mailmerge 1 April 7th 05 07:48 AM
Mergefield format Ctay Mailmerge 2 February 19th 05 10:51 PM


All times are GMT +1. The time now is 07:15 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"