email merge w/attachments:compile error-user defined type not defi

I've tried to follow all the steps and feel like I'm almost there, but when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel 12.0
Object Library checked. Not sure what to do now. Help!

I'm sure Doug will have the answer but meanwhile, since you are
referencing Excel as well, you may need to qualify any of the
declarations that reference a type that can be either in the Excel or
Word object models. e.g.

change

Dim Datarange As Range

to

Dim Datarange As Word.Range

(because there is a different Excel.Range)

Maybe also change

Dim Source As Document, Maillist As Document, TempDoc As Document

to

Dim Source As Word.Document, Maillist As Word.Document, TempDoc As
Word.Document

although I do not think there is any clash in this case.

Peter Jamieson

http://tips.pjmsn.me.uk

patricia wrote:
I've tried to follow all the steps and feel like I'm almost there, but when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel 12.0
Object Library checked. Not sure what to do now. Help!

What line of code is highlighted when you receive that error message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there, but
when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel
12.0
Object Library checked. Not sure what to do now. Help!

oOutlookApp As Outlook.Application and when I hit enter, the Sub line is
highlighted.

"Doug Robbins - Word MVP" wrote:

What line of code is highlighted when you receive that error message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there, but
when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel
12.0
Object Library checked. Not sure what to do now. Help!

I tried adding the Word. in those 4 instances, but I'm still getting the
compile error.

"Peter Jamieson" wrote:

I'm sure Doug will have the answer but meanwhile, since you are
referencing Excel as well, you may need to qualify any of the
declarations that reference a type that can be either in the Excel or
Word object models. e.g.

change

Dim Datarange As Range

to

Dim Datarange As Word.Range

(because there is a different Excel.Range)

Maybe also change

Dim Source As Document, Maillist As Document, TempDoc As Document

to

Dim Source As Word.Document, Maillist As Word.Document, TempDoc As
Word.Document

although I do not think there is any clash in this case.

Peter Jamieson

http://tips.pjmsn.me.uk

patricia wrote:
I've tried to follow all the steps and feel like I'm almost there, but when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel 12.0
Object Library checked. Not sure what to do now. Help!

I tried adding the Word. to those 4 instances, but I'm still getting the
compile error.


"Peter Jamieson" wrote:

I'm sure Doug will have the answer but meanwhile, since you are
referencing Excel as well, you may need to qualify any of the
declarations that reference a type that can be either in the Excel or
Word object models. e.g.

change

Dim Datarange As Range

to

Dim Datarange As Word.Range

(because there is a different Excel.Range)

Maybe also change

Dim Source As Document, Maillist As Document, TempDoc As Document

to

Dim Source As Word.Document, Maillist As Word.Document, TempDoc As
Word.Document

although I do not think there is any clash in this case.

Peter Jamieson

http://tips.pjmsn.me.uk

patricia wrote:
I've tried to follow all the steps and feel like I'm almost there, but when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel 12.0
Object Library checked. Not sure what to do now. Help!

That would indicate that the reference to the Outlook Object Library has not
been (properly) set or retained.

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
oOutlookApp As Outlook.Application and when I hit enter, the Sub line is
highlighted.

"Doug Robbins - Word MVP" wrote:

What line of code is highlighted when you receive that error message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there, but
when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel
12.0
Object Library checked. Not sure what to do now. Help!

I do that by going into the Word document, selecting Developer, then Visual
BasicToolsReferences, right? Then check the box next to Microsoft Outlook
Object Library 12.0. It was checked, but now it's not, so you're right, it's
not being retained. Why do you think that would be?

(By the way, I noticed in other postings that Tammy had the same error
message; she was able to click the box and got it working. Not sure why my
fix hasn't been so easy, but I'm trying).

Thank you so much for your help.

Patricia

"Doug Robbins - Word MVP" wrote:

That would indicate that the reference to the Outlook Object Library has not
been (properly) set or retained.

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
oOutlookApp As Outlook.Application and when I hit enter, the Sub line is
highlighted.

"Doug Robbins - Word MVP" wrote:

What line of code is highlighted when you receive that error message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there, but
when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel
12.0
Object Library checked. Not sure what to do now. Help!

I got it - yeah! And you're right, Doug, just follow the steps. I ended up
starting over and doing it one by one. I believe my problem was that I was
not merging into a new document.....Thanks so much for your help.

"patricia" wrote:

I do that by going into the Word document, selecting Developer, then Visual
BasicToolsReferences, right? Then check the box next to Microsoft Outlook
Object Library 12.0. It was checked, but now it's not, so you're right, it's
not being retained. Why do you think that would be?

(By the way, I noticed in other postings that Tammy had the same error
message; she was able to click the box and got it working. Not sure why my
fix hasn't been so easy, but I'm trying).

Thank you so much for your help.

Patricia

"Doug Robbins - Word MVP" wrote:

That would indicate that the reference to the Outlook Object Library has not
been (properly) set or retained.

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
oOutlookApp As Outlook.Application and when I hit enter, the Sub line is
highlighted.

"Doug Robbins - Word MVP" wrote:

What line of code is highlighted when you receive that error message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there, but
when I
run the macro I get the above error message. I've checked to see that
VBToolsReferences has Microsoft Word 12.0 Object Library, Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft Excel
12.0
Object Library checked. Not sure what to do now. Help!

Glad you got it working.

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I got it - yeah! And you're right, Doug, just follow the steps. I ended
up
starting over and doing it one by one. I believe my problem was that I
was
not merging into a new document.....Thanks so much for your help.

"patricia" wrote:

I do that by going into the Word document, selecting Developer, then
Visual
BasicToolsReferences, right? Then check the box next to Microsoft
Outlook
Object Library 12.0. It was checked, but now it's not, so you're right,
it's
not being retained. Why do you think that would be?

(By the way, I noticed in other postings that Tammy had the same error
message; she was able to click the box and got it working. Not sure why
my
fix hasn't been so easy, but I'm trying).

Thank you so much for your help.

Patricia

"Doug Robbins - Word MVP" wrote:

That would indicate that the reference to the Outlook Object Library
has not
been (properly) set or retained.

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
oOutlookApp As Outlook.Application and when I hit enter, the Sub line
is
highlighted.

"Doug Robbins - Word MVP" wrote:

What line of code is highlighted when you receive that error
message?

--
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, originally posted via msnews.microsoft.com
"patricia" wrote in message
...
I've tried to follow all the steps and feel like I'm almost there,
but
when I
run the macro I get the above error message. I've checked to see
that
VBToolsReferences has Microsoft Word 12.0 Object Library,
Microsoft
Office
12.9 Office Library, Microsoft Outlook 12.0 Library and Microsoft
Excel
12.0
Object Library checked. Not sure what to do now. Help!