How do I use mail merge fields with charts in Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim HR - 15 Mar 2006 18:32 GMT

I am creating mail merge letters that include a chart that I want to base on
mail merge fields. Is this possible, or will I need to manually update the
chart in each merged letter?

Reply to this Message

Doug Robbins - Word MVP - 15 Mar 2006 20:08 GMT

See the "Merge to a chart" item on fellow MVP Cindy Meister's website at:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am creating mail merge letters that include a chart that I want to base
>on
> mail merge fields. Is this possible, or will I need to manually update
> the
> chart in each merged letter?

Reply to this Message

AJO - 20 Feb 2008 15:06 GMT

Hello,

I've been using Cindy's method for a few years and it has worked
wonderfully. We have now upgraded to Office 2007, and I'm running into
problems. When I try to run the macro, I get a Run-time Error '91' - Object
variable or With block variable not set. Any suggestions?

Thanks,
AO

> See the "Merge to a chart" item on fellow MVP Cindy Meister's website at:
>
[quoted text clipped - 5 lines]
> > the
> > chart in each merged letter?

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 05:44 GMT

Show us the code of the macro that you are using?

Have you tried debugging/compiling it in the VBE to determine which command
is causing the error.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 17 lines]
>> > the
>> > chart in each merged letter?

Reply to this Message

AJO - 21 Feb 2008 14:27 GMT

I think the problem starts here:

Set tbl = DataDoc.Tables(1)
'Activate the MS Graph object in the
'main merge document
Set of = rng.InlineShapes(1).OLEFormat
of.DoVerb wdOLEVerbInPlaceActivate (this is where the error occurs)

> Show us the code of the macro that you are using?
>
[quoted text clipped - 22 lines]
> >> > the
> >> > chart in each merged letter?

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 22:40 GMT

Do you have a reference set to the Microsoft Graph 12.0 Object Library under
Tools>References in the Visual Basic Editor?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I think the problem starts here:
>
[quoted text clipped - 33 lines]
>> >> > the
>> >> > chart in each merged letter?

Reply to this Message

AJO - 27 Feb 2008 18:01 GMT

Yes, I do have that reference selected.

> Do you have a reference set to the Microsoft Graph 12.0 Object Library under
> Tools>References in the Visual Basic Editor?
[quoted text clipped - 36 lines]
> >> >> > the
> >> >> > chart in each merged letter?

Reply to this Message