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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 05:43 AM |
WP merge file to Word | sstires | Tables | 4 | February 14th, 2006 06:26 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Mail merge conversion from Word to .NET code. | mutton | Mailmerge | 1 | November 17th, 2004 02: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 |