MatthewFace
New Member
- Joined
- Sep 1, 2019
- Messages
- 1
Hi,
New to this forum as I cannot work out how to solve an issue that I have come across since we migrated our corporate email system from Lotus Notes to Office 365. Mr Excel has helped me a lot, by reviewing other peoples problems and proposed solutions, but I cannot find anthing on my current specific problem.
I have written code that pastes a URL (to a Lotus Notes address) into a text string which is then used to create an email automatically. In the past, with Lotus Notes email, it worked perfectly. Since we migrated to O365, the link is not recognised by the Outlook 365 web interface (the desktop Outlook application does recognise the URL and takes you to the associated address).
When I edit the sent / received email in the desktop app and place the cursor at the end of the link (which is recognised), there is a space before the line return. If I hit 'Enter' and save the edited email and then view it in O365 web email, the link is now recognised.
I have looked at my Excel VBA code and there is no space after the URL when I create the email. I get the URL from an email copied into the clipboard and my code parses the email to extract the URL, which it then inserts into the text used to create the email body before automatically send it.
I think this is a problem with HTML emails, but was wondering if there is anything I can change or add to the URL string when I create the email from Excel, that will allow the URL to be recognised by web Outlook automatically?
I hope I have explained this well enough for you to advise me if there is an easy solution.
Thank You
New to this forum as I cannot work out how to solve an issue that I have come across since we migrated our corporate email system from Lotus Notes to Office 365. Mr Excel has helped me a lot, by reviewing other peoples problems and proposed solutions, but I cannot find anthing on my current specific problem.
I have written code that pastes a URL (to a Lotus Notes address) into a text string which is then used to create an email automatically. In the past, with Lotus Notes email, it worked perfectly. Since we migrated to O365, the link is not recognised by the Outlook 365 web interface (the desktop Outlook application does recognise the URL and takes you to the associated address).
When I edit the sent / received email in the desktop app and place the cursor at the end of the link (which is recognised), there is a space before the line return. If I hit 'Enter' and save the edited email and then view it in O365 web email, the link is now recognised.
I have looked at my Excel VBA code and there is no space after the URL when I create the email. I get the URL from an email copied into the clipboard and my code parses the email to extract the URL, which it then inserts into the text used to create the email body before automatically send it.
I think this is a problem with HTML emails, but was wondering if there is anything I can change or add to the URL string when I create the email from Excel, that will allow the URL to be recognised by web Outlook automatically?
I hope I have explained this well enough for you to advise me if there is an easy solution.
Thank You