Hi,
Hope some can help. I'm trying to create an excel macro that can send emails with an attached file per row of my entry in excel I imagine it would be like the screenshot below. I've tried the code in the link below from a macro tutorial website but wasn't able to make it work due to error DataObject is unkown I'm using excel 2013 and lotus notes 8.5 as my email. Thanks appreciate any help i can get.
http://www.rondebruin.nl/win/s1/notes/notes5.htm
excel macro.JPG
Did you enable the reference for Microsoft Forms 2.0 Object Library like it says in the email?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
no. couldn't find this option in excel 2013
The code cant work without the proper references. Did you try looking for one similar?
I can't actually find the references tab in excel 2013. can you direct me to where I can find this option?
VBE->Tools->references is what I think it is...
I am running some scripts so I cant view anything on excel at the time being.
found it thanks miketron!
Did it work once you enabled the references?
Yup it did it works perfectly now. thanks.
Last edited by lmcpara; 08-07-2014 at 12:24 AM.
Can you mark this solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks