Hey All,
I'm currently trying to do something I've never done before and am just wondering if it is possible.
Basically, I have an excel document which requires a user to go in and fill out a bunch of information. After they do so, they click a button i put there and it saves it to a networked folder. This all works fine, but I also want an email to be sent to a few people notifying them that a new form has been saved. I know how to Email and all with VBA, but the problem comes in here that the user that submitted this form does not have an email account.
So my question is, is there some way to maybe send an email using VBA from no one in particular? Or would I have to have an email account set up for this reason alone, and then the VBA could access that email account and send an email from it? Without actually loading Outlook (to keep the security away from the user submitting the form).
Bookmarks