How do you create a pie chart with mail merge

[sherobot]

I'm trying to create a document that needs to be mail merged. My question is
how can I use mail merge in a pie chart?

thanks

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?c2hlcm9ib3Q=?=,

I'm trying to create a document that needs to be mail merged. My question is
how can I use mail merge in a pie chart?

Mail merge IN a pie chart? Well, that's not possible. Including a pie chart in
mail merge is just barely possible, but takes a lot of work or a good bit of
advanced macro coding. you'll find a discussion on the topic, with sample macro
code, in the mail merge FAQ on my website.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[sherobot]

Hey Cindy!
Thank you so much, your macro works great!.
yeah I did mean ... "including a pie chart in a mail merge."

My only question is now that I have it working, I tried changing the data to
my own table and for some reason it only merges 2 of the 4 columns that I
need to show. How can I get the other 2 columns to display in the chart?

For example the data I have in the columns are:
Salary
Life
Accidental
Year Span

After the mail merge runs it only shows on the pie chart Life and Year Span.
I've changed it several times in the original (letter before the merge), but
once the merge runs it converts back to 2

hope this makes sense.

she-robot

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?c2hlcm9ib3Q=?=,

This seems to be, in part, a machine configuration issue. I rarely see this
behavior on my machine; others see it all the time. I went through the hoops
with Microsoft on this, and the verdict there was that one needs to set the
PAUSE argument of MailMerge.Execute to FALSE.

Thank you so much, your macro works great!.
yeah I did mean ... "including a pie chart in a mail merge."

My only question is now that I have it working, I tried changing the data to
my own table and for some reason it only merges 2 of the 4 columns that I
need to show. How can I get the other 2 columns to display in the chart?

For example the data I have in the columns are:
Salary
Life
Accidental
Year Span

After the mail merge runs it only shows on the pie chart Life and Year Span.
I've changed it several times in the original (letter before the merge), but
once the merge runs it converts back to 2

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail