Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MaxArk[_27_] MaxArk[_27_] is offline
external usenet poster
 
Posts: 1
Default Midnight Time Value Improperly Merging


I am merging a time value into a mail merge document from an Excel
source.
Despite my merge field being formatted {MERGERFIELD"SubRespEnd"\@ "h:mm
am/pm" } 12:00AM is being displayed as 1/1/1900.

Is anyone able to shed some light on the cause and a possible solution?




--
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 Midnight Time Value Improperly Merging

What is the data source?

Using Office 2007 with an data in an Excel spreadsheet with the cells
containing the data formatted as *1:30:55 PM, so that entering 0 in a cell
displays 12:00:00 AM and then using that spreadsheet as a mail merge data
source without any formatting switch, the data is displayed in the Word
document as 12:00:00 AM. Adding the \@ "h:mm AM/PM" switch to the field,
it is displayed as 12:00 AM

If I use a custom format h:mm AM/PM in Excel, 0 entered into a cell displays
as 12:00 AM and the behaviour when it is merged into Word is identical to
the above, 12:00:00 AM without the switch and 12:00 AM with it.

This holds for both a DDE connection to the data source as well as an OLE DB
(Database) 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, originally posted via msnews.microsoft.com

"MaxArk" wrote in message
...

I am merging a time value into a mail merge document from an Excel
source.
Despite my merge field being formatted {MERGERFIELD"SubRespEnd"\@ "h:mm
am/pm" } 12:00AM is being displayed as 1/1/1900.

Is anyone able to shed some light on the cause and a possible solution?




--
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
Merging Time field from Word 2007 KHaberwoman Mailmerge 1 March 20th 10 04:03 AM
Improperly Displayed MergeField Format MaxArk[_11_] Mailmerge 1 May 29th 08 08:43 PM
Merging Time Fields Kim Mailmerge 10 May 27th 08 05:11 PM
Mailmerge data displays improperly Mikey Mailmerge 1 March 19th 07 09:21 PM
linking documents together and mail merging at the same time carrol Mailmerge 5 June 15th 05 04:33 PM


All times are GMT +1. The time now is 07:51 PM.

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

About Us

"It's about Microsoft Word"