Improperly Displayed MergeField Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaxArk - 29 May 2008 16:02 GMT

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

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

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

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

--
MaxArk

Reply to this Message

Doug Robbins - Word MVP - 29 May 2008 20:43 GMT

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.

Signature

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

> 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
[quoted text clipped - 10 lines]
>
> Where should I be looking to find the source of this problem?

Reply to this Message