Hi all,
I have the following commonly used macro to email a workbook via outlook:
however it has stopped working for me and I'm wondering if anyone has any ideas why this might be?
Please Login or Register to view this content.
The code worked fine a few weeks ago, but now goes through the process to the end (msgbox pops up), but doesn't seem to send any email.
Last edited by j.farr3ll; 04-16-2014 at 03:33 AM.
Hi, comment out On Error Resume Next statement and see what is the error that will be raised
If you are pleased with a member's answer then use the Star icon to rate it.
Perhaps you could use this add-in for mailing? Very versatile and works well
Hi buran,
I am getting the error on the following line:
the error is:Please Login or Register to view this content.
Run-time error '-2147352567 (80020009)':
The object does not support this method
It should be
Actually I don't know how I didn't see it right from the beginning.Please Login or Register to view this content.
I have found the problem. The line of codeshould have readPlease Login or Register to view this content.Just a typing error.Please Login or Register to view this content.
Thanks everyone for looking and buran for pointing me in the right direction.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks