I want to merge a whole document (Ecxel) into my mail merge

[Caroline Wagner-Arends]

I am making a mail merge which I want to e-mail to
members of a football pool. Every one who signed in send
me a form with his or her forecasts in Excel. In the mail
merge I'm making I want to include this Excel-document,
so every one can see his own forecasts. I have an Excel
worksheet with al the mailing fields etcetera, but all
the forecasts I received are seperated documents. It's
not a problem to make a mail merge with all the fields in
the Excel adress file, but is it also possible to merge
these individual forecast documents into my e-mail
document? I tried to make a combination of the
INCLUDETEXT field and a merge field with the URL of the
forecast sheet, but this didn't worked ...

Who can help me?

Lot's of thanks, Caroline

 

[Cindy Meister -WordMVP-]

Hi Caroline,

I tried to make a combination of the
INCLUDETEXT field and a merge field with the URL of the
forecast sheet, but this didn't worked ...

Hmmm, sounds like a good approach to me. But Word probably
won't pick up a URL; it prefers a file path. And if you're
bringing in the entire file path (rather than just the file
name) you need to double the backslashes:

{ IncludeText "C:\\Sheets\\ExcelWB.xls" }

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