E-mail merge of Word and Excel documents...

[John Heitmuller.]

Does anybody have any conceptual guidance on how to handle this e-mail
merge scenario?

I am starting with two documents an Excel Spread sheet containing
client statements and a Word document containing personalized
statement cover letters. The Excel spreadsheet has one client
statement on each tabbed worksheet. The Word document has one
statement cover letter per page.

I need to perform an e-mail merge that e-mails the matched statement
and cover letter to the appropriate e-mail address.

Anybody got any advice on how to approach this? Is there any off the
shelf software that can handle this?

Thanks,
John

 

[Peter Jamieson]

I guess you probably made your decisions, but...
a. I don't think there is any simple way to do it
b. Assuming that there is a simple (1-1?) correspondence between the Word
documents and the Excel tabs, I would probably keep it simple and write code
to split the Word document and the |Excel workbook into their constituent
parts and take it from there.