How are the spreadsheets related to the individuals, so that a merge would
know how to pick the correct one?
It *might* work if you conditionally insert a link to the workbook, if the
sheets each had a range name relating to a field in the merge data source -
something like
{ LINK Excel.Sheet.8 "D:\\My Documents\\Filename.xls" {Mergefield
FieldWithRangename} } I have not tested this with a merge but it works with
individual records when the range name is hard coded.
It might work if you had separate workbooks for each user and use an
INCLUDETEXT field, though you would need the old converter (download from my
web site) and it will throw a security message for each record. You would
need to name the Excel document to match a field in your data source and
then you can use something like
{ INCLUDETEXT "D:\\My Documents\\{Mergefield fieldname}.xls" }
Let me know if the link works as it has the makings of a new web page item
You may find
http://www.gmayor.com/formatting_word_fields.htm useful
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Dixie Folzenlogen wrote:
CLARIFICATION: I have looked at previous posts but they seem to
apply to e-mails. I am not wanting to generate e-mail attachments.
Just letters with attachments.
"Dixie Folzenlogen" wrote:
I have 10-15 spreadsheets in an Excel workbook which are specific to
individuals. I also have a spreadsheet in the same workbook which
is used to generate a mail merge letter to individuals. The
spreadsheets which are specific to the individuals need to be
printed as an "attachment" to the letters. Can anywho tell me how
to do it or point me to documentation? Thanks.