Problems merging an excel file due to code or file problems?
 

Hi ?B?SmFzb24gTA==?=,

[Coming from the Word.mailmerge.fields group]

Which version of Word/OFfice are we dealing with, here?

What issue were you having with "text" fields, more exactly?

Is the data range in the Excel table on the first sheet? Does it start in cell
A1? Have you applied a range name to it? You probably should do the last, at
the very least.

I posted an earlier question regarding formatting excel cells as text for
importing purposes. That seems to be working okay, but now I have another
problem. After this file has been saved, I need to merge it into a Word
source. When I do this, I step through the merge wizard, and after I choose
the Excel sheet and click OK, I get another strange window asking me to
select a table. Thing is, there is no table to select. I have to click
Cancel. If I try to click OK it say Word unable to open Merge Source. I
don't know what I did or what happened. I've tried this several times by
changing the cells formatted as text (errors were displayed cells because
they were formatted as text) to General. Still didn't work. I am posting
this on Word sites, because I don't receive this error until I try to merge
with Word. I don't think it has much to do with Word, though. Here is my
code. I am basically trying to figure out if there is something in my code
that could have screwed up this process. It was working fine before I
altered the code to format the first five cells as text.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)