Pulling info from Outlook using VBA

Hi, try this

Please Login or Register  to view this content.

Thanks for your reply. My reference to "certain" MailItems was intended to mean properties of Outlook not particular e-mails. For instance if the below code is used, it works fine. Also, I am choosing a folder which only has e-mails in it (it doesn't have any meeting notices, etc.)

Please Login or Register  to view this content.

But if the lines with "SenderName, SenderEmailAddress, and Body" are added back in, I get the errors referenced in my previous post.

Also, the below code doesn't work either and contains a specific reference to mail items (the line with "If objItem.Class = olMail"), so I don't think the class of the item is the issue.

Please Login or Register  to view this content.

Thanks again for your assistance.

Originally Posted by JEC.

Hi, try this

Please Login or Register  to view this content.

Thanks for your reply. I get the same errors as before with your code. Also like before, if I take out the line with SenderName, SenderEmailAddress, and Body, then it works fine.

Originally Posted by JEC.

What if you only comment out the body? Is it giving the error with the first item already?

Same error:

Run-time error '-2147467259 (80004005)':
Method 'SenderName' of object '_Mailltem' failed

I found a post on another forum re: a similar issue which contained the following:

"I had a similar problem, and it bugged the heck out of me. My eventual fix (workaround) was using a variable, which you wouldn't think would matter. Declare a string variable and then populate and use it."

Unfortunately, I don't know enough to use the fix described above.

Thanks.

Originally Posted by Excel3257705

Same error:

Run-time error '-2147467259 (80004005)':
Method 'SenderName' of object '_Mailltem' failed

I found a post on another forum re: a similar issue which contained the following:

"I had a similar problem, and it bugged the heck out of me. My eventual fix (workaround) was using a variable, which you wouldn't think would matter. Declare a string variable and then populate and use it."

Unfortunately, I don't know enough to use the fix described above.

Thanks.

The post described above stating using string variables was the solution in a similar instance is #57490 from accessforums dot net

This morning I posted this same question to the Experts Exchange website. If I receive an answer I will post it here. Thanks.