Chart on a Mail Merged Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shariq - 01 Mar 2007 23:56 GMT

I have a MS Word 2003 Mail Merged document with data source in Excel 2003.
1. I know how to create charts but don't know how to create charts in a mail
merged document?

2. When data is merged on some field; the number are displaying a bunch of
decimal points e.g. 48.909112233454656

Reply to this Message

Peter Jamieson - 02 Mar 2007 09:42 GMT

For the chart thing, see Cindy Meister's web site at

http://homepage.swissonline.ch/cindymeister/

Look for "Mail Merge FAQ"|"Special Merges"|"Merge with Chart"

For the number, see http://tips.pjmsn.me.uk/t0003.htm for a lengthy
explanation, but in this case what will probably work is to use a numeric
format switch in your Word merge field, e.g. change

{ MERGEFIELD mynumber }
to
{ MERGEFIELD mynumber \#"0.00" }

Peter Jamieson

>I have a MS Word 2003 Mail Merged document with data source in Excel 2003.
> 1. I know how to create charts but don't know how to create charts in a
[quoted text clipped - 4 lines]
> of
> decimal points e.g. 48.909112233454656

Reply to this Message

Shariq - 05 Mar 2007 23:59 GMT

Peter,
Thanks, it worked.

> For the chart thing, see Cindy Meister's web site at
>
[quoted text clipped - 19 lines]
> > of
> > decimal points e.g. 48.909112233454656

Reply to this Message