Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sherobot
 
Posts: n/a
Default How do you create a pie chart with mail merge

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default How do you create a pie chart with mail merge

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

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sherobot
 
Posts: n/a
Default How do you create a pie chart with mail merge

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 a
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-" wrote:

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


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP- Cindy M  -WordMVP- is offline
external usenet poster
 
Posts: 370
Default How do you create a pie chart with mail merge

Hi ?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 a
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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie chart in a Word Mail Merge AntonioR20 Mailmerge 1 February 25th 06 10:50 AM
Need to Create a Client Directory Mail Merge Document zachmattsmom Mailmerge 1 October 13th 05 09:02 PM
How do I create a Mail Merge with Voting Buttons using Word and O. research03 Mailmerge 0 April 21st 05 05:53 PM
Can you create a multi-layered merge where certain merge fields a. mileszat Mailmerge 3 January 18th 05 04:46 AM
How do I create a greeting line in Mail Merge that says "Dear Dr.. mrose Mailmerge 1 December 28th 04 09:20 PM


All times are GMT +1. The time now is 09:51 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"