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?

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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?

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

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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]

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" wrote in message
...
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" wrote:

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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?

[AJO]

I think the problem starts he

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

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" wrote in message
...
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" wrote:

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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]

Do you have a reference set to the Microsoft Graph 12.0 Object Library under
ToolsReferences 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" wrote in message
...
I think the problem starts he

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

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" wrote in message
...
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" wrote:

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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?

[AJO]

Yes, I do have that reference selected.

"Doug Robbins - Word MVP" wrote:

Do you have a reference set to the Microsoft Graph 12.0 Object Library under
ToolsReferences 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" wrote in message
...
I think the problem starts he

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

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" wrote in message
...
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" wrote:

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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?

[Amy Brooks]

Hi,

I know your post is an old one, but I have come across this same problem. I
seem to be able to get it working if I manually select the chart before
running the macro.

Hope this helps!

Amy



"AJO" wrote:

Yes, I do have that reference selected.

"Doug Robbins - Word MVP" wrote:

Do you have a reference set to the Microsoft Graph 12.0 Object Library under
ToolsReferences 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" wrote in message
...
I think the problem starts he

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

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" wrote in message
...
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" wrote:

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

http://homepage.swissonline.ch/cindy...r/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

"Kim HR" Kim wrote in message
...
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?