A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2006, 06:32 PM posted to microsoft.public.word.mailmerge.fields
external usenet poster
 
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  
Old March 15th, 2006, 08:08 PM posted to microsoft.public.word.mailmerge.fields
external usenet poster
 
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  
Old February 20th, 2008, 04:06 PM posted to microsoft.public.word.mailmerge.fields
AJO
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  
Old February 21st, 2008, 06:44 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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  
Old February 21st, 2008, 03:27 PM posted to microsoft.public.word.mailmerge.fields
AJO
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  
Old February 21st, 2008, 11:40 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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  
Old February 27th, 2008, 07:01 PM posted to microsoft.public.word.mailmerge.fields
AJO
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  
Old March 18th, 2010, 01:44 PM posted to microsoft.public.word.mailmerge.fields
Amy Brooks
external usenet poster
 
Posts: 12
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?









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th, 2006 06:43 AM
WP merge file to Word sstires Tables 4 February 14th, 2006 07:26 PM
How to change merge forms from Word Perfect to Microsoft Word Charles Kenyon General Discussion 1 December 30th, 2004 04:35 PM
Mail merge conversion from Word to .NET code. mutton Mailmerge 1 November 17th, 2004 03:09 AM
How to run word and pass a mail merge values and fax it to the recipient Belinda Mailmerge 2 June 13th, 2004 12:49 AM


All times are GMT +1. The time now is 02:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.