Run-time error '-2114715382 (81f4010a)':
Method 'To' of object '_MailItem failed
this is the error message i am getting on this code - BUT only on one laptop. this code is used by multiple people using different office versions and different operating systesm (7 and 8.1). i am highlighting the line where the code stops. any suggestions would be great. the specs of teh laptop that this error is occuring on are - windows 8.1 and office 2013
Please Login or Register to view this content.
One idea... in the VBEditor check the Tools > References in a computer where it is working correctly and make sure the laptop has the same refs.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
will do that now thanks Jerry
so the references were the same. what i did was add .text to the end of the .to line
and now it is workingPlease Login or Register to view this content.
The same error was happening to me when trying to send a mail based on information inside a UserForm.
The function for the e-mail was receiving the textboxes as parameter, and not their value (e.g: TxtBox.Value instead of simply TxtBox).
Remember to always pass the specific property and it should work fine!
Thank you for your help. I was getting the same error but with the Method 'Subject' of object. This helped me greatly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks