I have an Excel Userform that emails worksheet with a command button.
However, I need to take this a step further and when the receiver opens the
email . I would like to automatically send a response to sender. Can this
be accomplished? If so can anyone please help/guide me how to do? Or where
I can find out how to do? Email application using Outlook. thank you in
advance for any help with this. Thank you.