Hi, this is my first post and I'm a macro-n00b so please go easy :)
My aim was to make a macro that took the workbook I was in, attached it to a fresh Outlook Express email, and then filled in the To, BCC, Subject and Body. (This would enable staff to just complete the banking, press the button and fire off the workbook to finance with a uniform description in the body of the email.)
This macro works perfectly. Once. And then I get System Error &H80070020 (-2147024864) thereafter - unless I make the file Read Only, and then it continues to work fine. But I don't want the file to be Read Only because that means not-IT-savvy staff will need to mess about with it, so the help I need is making it so this works every time instead of just once, please. (Obviously, I've anonymised and simplified the email contents.)
All help gratefully received! :)
Bookmarks