Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Set itm = doc.MailEnvelope.Item (http://www.outlookbanter.com/outlook-vba/47714-set-itm-doc-mailenvelope-item.html)

[email protected] May 7th 07 04:18 PM

Set itm = doc.MailEnvelope.Item
 
Hello Everyone,

I'm getting a runtime error that says: Run-Time error '-2147467259.
Method 'Mailenveloe' of object_document failed

I have read every posting about this and still can't seem to figure it
out. Whats wierd is that i've been using this macro for months and
all of a sudden this week it doesn't work! Any ideas on whats wrong?
The following is the code I'm using. Any help would be great as this
macro sends out about 100 emails. Also, outlook is my default
program.

Set itm = doc.MailEnvelope.Item
doc.MailEnvelope.Introduction = ActiveCell.Offset(0, 4).Value

THANKS!


Sue Mosher [MVP-Outlook] May 7th 07 07:09 PM

Set itm = doc.MailEnvelope.Item
 
I haven't seen an instance of that failing. Can the user send a document manually with the File | Send To command?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message ups.com...
Hello Everyone,

I'm getting a runtime error that says: Run-Time error '-2147467259.
Method 'Mailenveloe' of object_document failed

I have read every posting about this and still can't seem to figure it
out. Whats wierd is that i've been using this macro for months and
all of a sudden this week it doesn't work! Any ideas on whats wrong?
The following is the code I'm using. Any help would be great as this
macro sends out about 100 emails. Also, outlook is my default
program.

Set itm = doc.MailEnvelope.Item
doc.MailEnvelope.Introduction = ActiveCell.Offset(0, 4).Value

THANKS!


[email protected] May 7th 07 07:23 PM

Set itm = doc.MailEnvelope.Item
 
Yea, I can send the document as per normal. The helpdesk upgraded
office but they don't really know what the update was. Is there an
object I am missing? I'm assuming thats what it is.

Also, there was a typo in my previous email. The error was:

Run-Time error '-2147467259.
Method 'Mailenvelope' of object_document failed


Thanks!!

Sue Mosher [MVP-Outlook] wrote:
I haven't seen an instance of that failing. Can the user send a document manually with the File | Send To command?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message ups.com...
Hello Everyone,

I'm getting a runtime error that says: Run-Time error '-2147467259.
Method 'Mailenveloe' of object_document failed

I have read every posting about this and still can't seem to figure it
out. Whats wierd is that i've been using this macro for months and
all of a sudden this week it doesn't work! Any ideas on whats wrong?
The following is the code I'm using. Any help would be great as this
macro sends out about 100 emails. Also, outlook is my default
program.

Set itm = doc.MailEnvelope.Item
doc.MailEnvelope.Introduction = ActiveCell.Offset(0, 4).Value

THANKS!



Sue Mosher [MVP-Outlook] May 7th 07 08:33 PM

Set itm = doc.MailEnvelope.Item
 
I don't think there's anything missing, but good debugging would suggest expanding the code to get each object separately:

Set env = doc.MailEnvelope
Set itm = env.Item
strCell = ActiveCell.Offset(0, 4).Value
env.Introduction = strCell

but I suspect that will make no difference. Running Help | Detect and Repair is also a good move.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message oups.com...
Yea, I can send the document as per normal. The helpdesk upgraded
office but they don't really know what the update was. Is there an
object I am missing? I'm assuming thats what it is.

Also, there was a typo in my previous email. The error was:

Run-Time error '-2147467259.
Method 'Mailenvelope' of object_document failed


Thanks!!

Sue Mosher [MVP-Outlook] wrote:
I haven't seen an instance of that failing. Can the user send a document manually with the File | Send To command?



wrote in message ups.com...
Hello Everyone,

I'm getting a runtime error that says: Run-Time error '-2147467259.
Method 'Mailenveloe' of object_document failed

I have read every posting about this and still can't seem to figure it
out. Whats wierd is that i've been using this macro for months and
all of a sudden this week it doesn't work! Any ideas on whats wrong?
The following is the code I'm using. Any help would be great as this
macro sends out about 100 emails. Also, outlook is my default
program.

Set itm = doc.MailEnvelope.Item
doc.MailEnvelope.Introduction = ActiveCell.Offset(0, 4).Value

THANKS!




All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com