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

[Kim HR]

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?

 

[Doug Robbins - Word MVP]

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

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

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

 

[AJO]

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

 

[Doug Robbins - Word MVP]

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.

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

 

[AJO]

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)

 

[Doug Robbins - Word MVP]

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

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

 

[AJO]

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?

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