Hi there,

I'm trying to use the add-in that I downloaded from Graham's site
(http://www.gmayor.com/individual_merge_letters.htm) and I keep getting a
Microsoft Visual Basic error message that says: 'Compiler error in hidden
module: Merge Application' after I select "All" in the "Merge to New
Document" window.

I see that Pete had this same problem last week (1/9/06, merge to separate
files), and Doug gave some helpful troubleshooting information, however I'm
still getting the error message. I'm wondering if I have it installed
correctly, or if it has something to do with the way my system is set up. I
had one of our IT staff try setting it up as an adminstrator on my computer,
and we still got the same result, so I don't think that is what the problem
is.

System Info
I'm using Word 2002 SP3, operating on Windows XP Pro, Version 5.1.2600
Service Pack 2 Build 2600.
Does it matter that I don't use Outlook as my email program? I have Outlook
Express 6 installed on the system, but my company uses GroupWise (Novell
GroupWise 6.5) instead.

Settings Info
In Word, under ToolsTemplates and Add-ins, I have 3 files listed in the
'Global templates and add-ins' list:
- MMtoDocsRev16.dot
- PDFMaker.dot
- PDFMakerA.dot
Only the first two are checked as currently loaded items.

Under ToolsReferences in the Visual Basic Editor I only have the following
items checked in the Available References list:
- Visual Basic for Applications
- Microsoft Word 10.0 Object Library
- OLE Automation
- Microsoft Office 10.0 Object Library
- Microsoft Forms 2.0 Object Library

Is there any other system information that might be helpful?

Thanks,
Cara

On my system, using Word/Office 2003, its the Word 11.0 and Office 11.0
Object Libraries that are checked under References.

Outlook should not be coming into it. What is the data source for the mail
merge?



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

"C. Cunningham" wrote in message
...
Hi there,

I'm trying to use the add-in that I downloaded from Graham's site
(http://www.gmayor.com/individual_merge_letters.htm) and I keep getting a
Microsoft Visual Basic error message that says: 'Compiler error in hidden
module: Merge Application' after I select "All" in the "Merge to New
Document" window.

I see that Pete had this same problem last week (1/9/06, merge to separate
files), and Doug gave some helpful troubleshooting information, however
I'm
still getting the error message. I'm wondering if I have it installed
correctly, or if it has something to do with the way my system is set up.
I
had one of our IT staff try setting it up as an adminstrator on my
computer,
and we still got the same result, so I don't think that is what the
problem
is.

System Info
I'm using Word 2002 SP3, operating on Windows XP Pro, Version 5.1.2600
Service Pack 2 Build 2600.
Does it matter that I don't use Outlook as my email program? I have
Outlook
Express 6 installed on the system, but my company uses GroupWise (Novell
GroupWise 6.5) instead.

Settings Info
In Word, under ToolsTemplates and Add-ins, I have 3 files listed in the
'Global templates and add-ins' list:
- MMtoDocsRev16.dot
- PDFMaker.dot
- PDFMakerA.dot
Only the first two are checked as currently loaded items.

Under ToolsReferences in the Visual Basic Editor I only have the
following
items checked in the Available References list:
- Visual Basic for Applications
- Microsoft Word 10.0 Object Library
- OLE Automation
- Microsoft Office 10.0 Object Library
- Microsoft Forms 2.0 Object Library

Is there any other system information that might be helpful?

Thanks,
Cara

The datasource is a worksheet in Excel 2002 SP3.

I looked for the Word 11.0 and Office 11.0 options, and they aren't on my
list, so they must be used with the '03 version of Word.

I'm wondering, has anyone out there with Word 2002 been able to use the
add-in template successfully, or do I have to have Word 2003 to be able to
use it?

Sorry, I guess I misread the SP3 as 2003. I think however that it should
work in Word 2002.

Try unchecking the add-in ToolsTemplates and Add-ins, then open the .dot
file in Word and then open the visual basic editor select the project and
open each of the modules, classes in it and with the selection in each one
in turn, from the Debug menu in the visual basic editor, select Compile and
if you get an error. let us know what line of code is highlighted.

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

"C. Cunningham" wrote in message
...
The datasource is a worksheet in Excel 2002 SP3.

I looked for the Word 11.0 and Office 11.0 options, and they aren't on my
list, so they must be used with the '03 version of Word.

I'm wondering, has anyone out there with Word 2002 been able to use the
add-in template successfully, or do I have to have Word 2003 to be able to
use it?

Okay, you might need to bear with me, because although I'm an experienced
Word user, and have created tons of complex merges with embedded IF
statements, I've never actually gone into the VB editor before yesterday, so
this is a new world for me, and I might not use the proper terminology.

I turned off the add-in, and opened the template, but the add-in was still
turned on. I can't get the change to stick. I unchecked the add-in again
and opened the VB editor. I went to ViewProject Explorer and opened the
"Modules" folder, under which I have two files "Module1" and "Printers". I
also have a "Class Modules" folder which contains the file "Merge
Application".

When I select any of the 3 files, and select DebugCompile TemplateProject,
I get an error message that reads:

Compile error:
Can't find project or library

After clicking OK, it takes me to the References - TemplateProject Dialog
box and the Microsoft Outlook 11.0 Object Library reference is preceded by
"MISSING:".

According to the help files, I should browse my system to look for the
missing reference, but I don't know where to look.

Doug will no doubt be along later to correct me if I am wrong, but in this
case the Microsoft Outlook 11.0 Object Library reference is for Office 2003.
If you look up tools references, you should find the Microsoft Outlook
10.0 Object Library. Check that one and save. If that doesn't fix it I think
we need to wait and see what call Doug is using from that library. Let us
know either way as my web site will need a note to reflect the changes
required to fix this.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


C. Cunningham wrote:
Okay, you might need to bear with me, because although I'm an
experienced Word user, and have created tons of complex merges with
embedded IF statements, I've never actually gone into the VB editor
before yesterday, so this is a new world for me, and I might not use
the proper terminology.

I turned off the add-in, and opened the template, but the add-in was
still turned on. I can't get the change to stick. I unchecked the
add-in again and opened the VB editor. I went to ViewProject
Explorer and opened the "Modules" folder, under which I have two
files "Module1" and "Printers". I also have a "Class Modules" folder
which contains the file "Merge Application".

When I select any of the 3 files, and select DebugCompile
TemplateProject, I get an error message that reads:

Compile error:
Can't find project or library

After clicking OK, it takes me to the References - TemplateProject
Dialog box and the Microsoft Outlook 11.0 Object Library reference is
preceded by "MISSING:".

According to the help files, I should browse my system to look for the
missing reference, but I don't know where to look.

While for other purposes on my machine, I do have a reference to the
Microsoft Outlook 11.0 Object Library, there is nothing in that Mail Merge
to Docs add-in that is using anything from that library. Try unchecking the
add-in from the ToolsTemplates and Add-in menu item again, then open the
Visual Basic Editor, and select that project and then somewhere in one of
the modules, press the Enter Key (just so that the system thinks that it has
been changed) and then on the toolbar in the Visual Basic Editor, click on
the Save button.

Then, shut down Word completely, then re-start it and see if it works.

Please do let us know how you get on.

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

"C. Cunningham" wrote in message
...
Okay, you might need to bear with me, because although I'm an experienced
Word user, and have created tons of complex merges with embedded IF
statements, I've never actually gone into the VB editor before yesterday,
so
this is a new world for me, and I might not use the proper terminology.

I turned off the add-in, and opened the template, but the add-in was still
turned on. I can't get the change to stick. I unchecked the add-in again
and opened the VB editor. I went to ViewProject Explorer and opened the
"Modules" folder, under which I have two files "Module1" and "Printers".
I
also have a "Class Modules" folder which contains the file "Merge
Application".

When I select any of the 3 files, and select DebugCompile
TemplateProject,
I get an error message that reads:

Compile error:
Can't find project or library

After clicking OK, it takes me to the References - TemplateProject Dialog
box and the Microsoft Outlook 11.0 Object Library reference is preceded by
"MISSING:".

According to the help files, I should browse my system to look for the
missing reference, but I don't know where to look.

Cara,

I think that I have tracked down the problem, so if what I suggested in my
earlier post does not work, if you can send me your email address, I will
send a revised add-in. Alternatively, I have sent the revision to Graham so
he should add it to his website fairly soon.

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

"C. Cunningham" wrote in message
...
Okay, you might need to bear with me, because although I'm an experienced
Word user, and have created tons of complex merges with embedded IF
statements, I've never actually gone into the VB editor before yesterday,
so
this is a new world for me, and I might not use the proper terminology.

I turned off the add-in, and opened the template, but the add-in was still
turned on. I can't get the change to stick. I unchecked the add-in again
and opened the VB editor. I went to ViewProject Explorer and opened the
"Modules" folder, under which I have two files "Module1" and "Printers".
I
also have a "Class Modules" folder which contains the file "Merge
Application".

When I select any of the 3 files, and select DebugCompile
TemplateProject,
I get an error message that reads:

Compile error:
Can't find project or library

After clicking OK, it takes me to the References - TemplateProject Dialog
box and the Microsoft Outlook 11.0 Object Library reference is preceded by
"MISSING:".

According to the help files, I should browse my system to look for the
missing reference, but I don't know where to look.