Cannot merge text from excel referenced cells, but numbers do work

J

Jim

I have created a MSExcel data source for my MSWord merge
document and can't merge any text, but I can merge numbers
without a problem. The excel data source has several
sheets, some are used for data entry and some a for merge
data sources. The sheets that are for data source merging
are all referenced to the other data entry sheets, so
there's a simple formula like, "='Sheet1'!E8", etc. If
the referenced cell contains text, the MSWord merge
document will show the fields in the merge drop down menu
but it will come across as "_________". If the referenced
cell contains numbers, it comes over without problems.
What am I doing wrong? Any help or comment is very much
appreciated.

Jim
 
C

Cindy Meister -WordMVP-

Hi Jim,

You still haven't told us which version of Word is
involved...
I have created a MSExcel data source for my MSWord merge
document and can't merge any text, but I can merge numbers
without a problem. The excel data source has several
sheets, some are used for data entry and some a for merge
data sources. The sheets that are for data source merging
are all referenced to the other data entry sheets, so
there's a simple formula like, "='Sheet1'!E8", etc. If
the referenced cell contains text, the MSWord merge
document will show the fields in the merge drop down menu
but it will come across as "_________". If the referenced
cell contains numbers, it comes over without problems.
What am I doing wrong? Any help or comment is very much
appreciated.
Click to expand...

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

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

Jim

I posted this yesterday and forgot to add I was using Word
2000, thanks for any help you can give.
 
C

Cindy Meister -WordMVP-

Hi Jim,

This is a problem with Word 2000. I think you'll have to do a
copy/paste values to another sheet (or workbook), then merge
to that.
I have created a MSExcel data source for my MSWord merge
document and can't merge any text, but I can merge numbers
without a problem. The excel data source has several
sheets, some are used for data entry and some a for merge
data sources. The sheets that are for data source merging
are all referenced to the other data entry sheets, so
there's a simple formula like, "='Sheet1'!E8", etc. If
the referenced cell contains text, the MSWord merge
document will show the fields in the merge drop down menu
but it will come across as "_________". If the referenced
cell contains numbers, it comes over without problems.
Click to expand...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Mail Merge - displaying a conditional number of decimals 5
Email Mail Merge via linked Excel sheet 0
Directory Mail Merge with table layout 2
Long Data Fields in Mail Merge 0
Is it possible to create a mail merge with unformatted text links to mergefield? 1
Mail merge hyperlink wrong results 0

Top