Blank fields in a merged document

Hi guys

I've got a merge document that feeds from an excel sheet, its all set up nicely and works by and large.... the problem is I have a date and time that exists in the excel file, the field names are accessible under the 'Insert Merge Field' button and it puts them in properly. When i merge tho it picks all the other fields up no probs but leaves the date and time blank... They're not blank in the excel sheet, they have formatted time and dates in them... I've never had the problem before and after much fiddling about I've come to a standstill.... anyone got any ideas????

Cheers in Advance

Andrew

And i forgot to mention I'm using Office 97 (Don't laugh!!!!)

----- Andrew elliott wrote: -----

Hi guys

I've got a merge document that feeds from an excel sheet, its all set up nicely and works by and large.... the problem is I have a date and time that exists in the excel file, the field names are accessible under the 'Insert Merge Field' button and it puts them in properly. When i merge tho it picks all the other fields up no probs but leaves the date and time blank... They're not blank in the excel sheet, they have formatted time and dates in them... I've never had the problem before and after much fiddling about I've come to a standstill.... anyone got any ideas????

Cheers in Advance

Andrew

Hi =?Utf-8?B?QW5kcmV3IGVsbGlvdHQ=?=,

I've got a merge document that feeds from an excel sheet, its all set up nicely and
works by and large.... the problem is I have a date and time that exists in the excel
file, the field names are accessible under the 'Insert Merge Field' button and it puts
them in properly. When i merge tho it picks all the other fields up no probs but leaves
the date and time blank... They're not blank in the excel sheet, they have formatted time
and dates in them... I've never had the problem before and after much fiddling about I've
come to a standstill.... anyone got any ideas????
Word97

The first thought that comes to my mind is that you may be using an ODBC connection? And
there may be a discrepancy with the data types?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)

Kind of made a workaround for it.... it appears that
because my excel sheet is about 40 columns wide and the
dates in question are AB & AC it won;t pick up the dates
from them.... bizarre but true.... so it looks as tho
there are a maximum number of colulms that word will pick
up from... well at least it works kinda...

cheers
-----Original Message-----
Hi =?Utf-8?B?QW5kcmV3IGVsbGlvdHQ=?=,

I've got a merge document that feeds from an excel
sheet, its all set up nicely and
works by and large.... the problem is I have a date and
time that exists in the excel
file, the field names are accessible under the 'Insert
Merge Field' button and it puts
them in properly. When i merge tho it picks all the other
fields up no probs but leaves
the date and time blank... They're not blank in the excel
sheet, they have formatted time
and dates in them... I've never had the problem before
and after much fiddling about I've
come to a standstill.... anyone got any ideas????
Word97

The first thought that comes to my mind is that you may
be using an ODBC connection? And
there may be a discrepancy with the data types?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the
newsgroup and not by e-mail :-)

.

Hi Andrew,

Kind of made a workaround for it.... it appears that
because my excel sheet is about 40 columns wide and the
dates in question are AB & AC it won;t pick up the dates
from them.... bizarre but true.... so it looks as tho
there are a maximum number of colulms that word will pick
up from... well at least it works kinda...

That makes me even more curious as to which kind of data
connection you're using. This sounds like Word's internal
spreadsheet converter? That would result in a maximum, as I
recall.

But an ODBC connection certainly wouldn't, nor should a DDE
connection...

Have you tried using "Select method" and seeing what you get
with the other connection methods?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)