Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kim HR
 
Posts: n/a
Default How do I use mail merge fields with charts in Word?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default How do I use mail merge fields with charts in Word?

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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AJO AJO is offline
external usenet poster
 
Posts: 3
Default How do I use mail merge fields with charts in Word?

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?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I use mail merge fields with charts in Word?

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?






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AJO AJO is offline
external usenet poster
 
Posts: 3
Default How do I use mail merge fields with charts in Word?

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?








  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I use mail merge fields with charts in Word?

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?








  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AJO AJO is offline
external usenet poster
 
Posts: 3
Default How do I use mail merge fields with charts in Word?

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?









  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Amy Brooks Amy Brooks is offline
external usenet poster
 
Posts: 2
Default How do I use mail merge fields with charts in Word?

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?









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
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merging formatted content donna Mailmerge 18 July 28th 06 06:20 PM
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 06:43 AM
How can I mail merge a .csv file, matching fields, into a Word doc Fluffy from Wisconsin Microsoft Word Help 3 May 19th 05 01:38 PM


All times are GMT +1. The time now is 06:24 AM.

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"