Outlook 365 Input - Separate Body lines

Hi all, I've just discovered the new Outlook 365 Input tool released in 2021.4 and installed and started using it.

I've found that the body preview and body fields both return the text joined up where there are separate lines in the real email. Here is an example of how it looks in Outlook with the text separated by lines:

Here is how the body preview and body fields return the data (copied into notepad):

This text shows that the tool currently doesn’t separate text from multiple lines in an emailWhen a new line is started the body does not separate themDoes anyone have any ideas on how to separate the lines?

Does anyone know a way to separate these? Many thanks

Input

Parse

Accepted answers

kkatushkin77

I have had experienced the same limitation with the Outlook 365 tool, which removes new line breaks from the message body. Notepad++ confirms that there no hidden characters. Given this is the current limitation of the tool, I have added the relevant suggestion to the Alteryx idea board, i.e. for the tool to retain new line separators when importing message body. I think it is an important feature enhancement, so please "like" the idea to promote it Outlook 365 - New Line Separator - Alteryx Community

All comments

gabrielvilella

In Alteryx, they are all together? If so, you'd have to have a pattern to separate them. I don't see one here based on what you posted.

danilang

Hi @AdamGSmith

Try pasting the text into a text editor where you can show special characters, like notepad++. Maybe the line breaks are not the standard CR\LF. If they aren't and you can figure out what they are, you can split to rows on these characters.

Dan

AdamGSmith

Thanks, direct copy paste into Notepad ++ gave the same result with no characters.

alex

Same issue, N++ shows CRLF when I copy and paste email from Outlook, but the tool won't parse the web form. Will have to stick to downloading into Access then pulling into Designer. Funny that tool recognizes spaces within the row that came from a tab, but not \t in the body or at the end before the CRLF. Not much good for me if I can't get to data in the body of the email.

kkatushkin77

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280