Greetings, did a search for this in the forum but I am not sure how to even phrase the search so I didn't find anything lol... I know that I can send an email, fill in the headers and bodies and such all with a macro, do that quite a bit. But is there a way to reverse that process? So that I can take data from an email and return it to a userform?
The application is that I use "comment" emails quite a bit in my userforms, the user can click a "comment" button that launches a small userform where they put in their name, comments, questions or what have you and it sends me the information in an email. This macro also automatically logs them in a WS so that I can keep track of the submitted comments. I usually simply respond manually by email, and manually create the response in this comments log. Works easy enough but it occurred to me that perhaps I can do all this automatically from the email itself. I know I can include a hyperlink in the original email that would open up a WB just by clicking it, I do that quite a bit as well.
So the question is - If a person was to click on this hyperlink which in turn would launch a WB. Could I have the userform that launches when the WB is opened transfer any data from the email back in to the userform? In other words, I can send excel data to and outlook email before it is sent, but can I send outlook data to excel?
Just wondering, thanks for any input
The application is that I use "comment" emails quite a bit in my userforms, the user can click a "comment" button that launches a small userform where they put in their name, comments, questions or what have you and it sends me the information in an email. This macro also automatically logs them in a WS so that I can keep track of the submitted comments. I usually simply respond manually by email, and manually create the response in this comments log. Works easy enough but it occurred to me that perhaps I can do all this automatically from the email itself. I know I can include a hyperlink in the original email that would open up a WB just by clicking it, I do that quite a bit as well.
So the question is - If a person was to click on this hyperlink which in turn would launch a WB. Could I have the userform that launches when the WB is opened transfer any data from the email back in to the userform? In other words, I can send excel data to and outlook email before it is sent, but can I send outlook data to excel?
Just wondering, thanks for any input