Hi All,
I have a vba macro that will import email from outlook to excel sheet. The body of the email is imported to column B of the excel sheet. In the outlook email body, there is a hyperlink embedded in a word (for eg. Abcd211). When I am importing it, the hyperlink is showing after the word and it is of almost multiple lines. I want to keep the hyperlink embedded in the word after importing as the original email. Please suggest how to resolve the issue.
I have a vba macro that will import email from outlook to excel sheet. The body of the email is imported to column B of the excel sheet. In the outlook email body, there is a hyperlink embedded in a word (for eg. Abcd211). When I am importing it, the hyperlink is showing after the word and it is of almost multiple lines. I want to keep the hyperlink embedded in the word after importing as the original email. Please suggest how to resolve the issue.