How do you create a pie chart with mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sherobot - 22 May 2006 20:49 GMT

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

Reply to this Message

Cindy M -WordMVP- - 23 May 2006 17:32 GMT

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 :-)

Reply to this Message

sherobot - 14 Jun 2006 15:36 GMT

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

> Hi =?Utf-8?B?c2hlcm9ib3Q=?=,
>
[quoted text clipped - 13 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 19 Jul 2006 20:25 GMT

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."
[quoted text clipped - 12 lines]
> 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 :-)

Reply to this Message