Mail Merge to excel spreadsheet problem

[Alex]

Hello,

I created a mailer using workd and within the body of the
mailer I created a excel spreadsheet within MS word. I
did a mail merge and it worked fine. I want to merge
some fields into the excel spreadsheet which is in word
and I cannot. Is there a way around this????? or is it
just not possible.

 

[Cindy M -WordMVP-]

Hi Alex,

I created a mailer using workd and within the body of the
mailer I created a excel spreadsheet within MS word. I
did a mail merge and it worked fine. I want to merge
some fields into the excel spreadsheet which is in word
and I cannot. Is there a way around this????? or is it
just not possible.

Not possible. And Excel spreadsheet (as an Excel object as
opposed to a sheet converted to a Word table) is like any
drawing object or picture, as far as Word is concerned. When
you activate it (double-click, for example), that opens the
object in its own application environment (Excel). And since
Excel doesn't know anything about merge fields...

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