mail merge Excel Graphs

[Betty Garrity]

Is it possible to create a mail merge document in Word
that imports an Excel graph based on data from a
spreadsheet (so that each letter that is mail merged has
a different graph based on a specific record's data)?

 

[Jon Peltier]

Betty -

I don't think it's possible through Word's Mail Merge routine, but it's
certainly possible to do through automation of Word by Excel (or vice
versa). I'd set up a table in a worksheet, which might include the
record being charted, or just a pointer to the record in another
worksheet table. For each letter, I'd put all the Name, Address, and
other stuff from the worksheet into the letter, then copy a picture of
the chart and paste it into the letter. Print or email, then loop to
the next letter.

- Jon