Blank fields in a merged document

[Andrew elliott]

Hi guy

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 Advanc

Andrew

 

[Andrew Elliott]

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

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

Hi guy

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 Advanc

Andrew

 

[Cindy M -WordMVP-]

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

 

[Andrew Elliott]

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=?=,

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

 

[Cindy M -WordMVP-]

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