Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
riri riri is offline
external usenet poster
 
Posts: 4
Default Time shows up instead of a date

Hello,

I m merging some data in an excel sheet that in some fields I m
getting 12:00:00 AM instead of a date I have tried everything but
nothing seems to be working. Can anyone help out?

Thanks in advance

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Time shows up instead of a date

This is often an indication of an empty field - 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. 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


riri wrote:
Hello,

I m merging some data in an excel sheet that in some fields I m
getting 12:00:00 AM instead of a date I have tried everything but
nothing seems to be working. Can anyone help out?

Thanks in advance



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
riri riri is offline
external usenet poster
 
Posts: 4
Default Time shows up instead of a date

Hello again,

I checked this option in word and then I try to open my excel sheet
to get the date for the mergge but I still get the 12:00:00 AM in some
of the records..If I have only that record in the excel sheet it is
working fine without giving me any 12:00:00AM. Therefore the fields
that appear with 12:00:00 AM are not empty. Is there any other
solution for this issue?

Thanks in advance





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
Format Date and Time to show Military Time AlanFD Microsoft Word Help 2 September 22nd 06 10:44 PM
I cannot turn off the Document Map. It shows every time I open a d genz_mail Microsoft Word Help 3 August 1st 06 05:03 PM
Blank date fields in Excel merging with Date/Time margaret Mailmerge 1 March 16th 06 04:36 PM
date/time automatic update is off but date still updates. jocasam Microsoft Word Help 2 February 11th 06 03:50 PM
long date formatting in access shows as short date in word farley Mailmerge 3 August 16th 05 04:45 AM


All times are GMT +1. The time now is 03:48 AM.

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"