Need VBA to add Excell charts to Mail Merge letter

[Richard A]

I have a mail merge letter that currently gets address data from an Excel
spreadsheet.
I also have another Excel spreadsheet of individual charts for each person
that gets the letter.
I have added a column to the address spreadsheet that stores the chart name
for each person.
What I want to do is develop VBA code in word to cycle through the letters
and paste the proper chart in the letter at a bookmark.
I have not been able to find the VBA for this.
Can anyone steer me to a solution?
Thanks in advance
Richard

 

[Doug Robbins]

You could send it as an attachment using the code in the article "Mail Merge
to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP