Updated Excel object in a mail-merge word document

[clickit]

hi to all,

i need your help

i have an excel file with 2 sheets containing data which i want to
show in a word document thru an OLE Excel object.
The document is created dynamicaly thru mail-merge and i cannot have
the Excel object updated dynamicaly too !!!

how can i do this ???

thanks in advance

 

[Cindy M -WordMVP-]

Hi Clickit,

i have an excel file with 2 sheets containing data which i want to
show in a word document thru an OLE Excel object.
The document is created dynamicaly thru mail-merge and i cannot have
the Excel object updated dynamicaly too !!!

I'm not quite sure I understand what you need. Let me try phrasing it
in my own words, and you tell me if I've got it right:
- you want to mail merge
- the mail merge result should contain Excel OLE objects
- these need to be linked to the source
- the link needs to change for each record in the mail merge?

This can be done, but you do have to add a field to the data source
that will carry the information necessary for the link. You can get an
idea of what this would be by copying such an Excel sheet, then using
Paste Special with Link in Word. Press Alt+F9 to see the LINK field
code this generates.

If you need more help, please also give us the version of Office
involved.

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