I reopen here the bug #177398 : "When pasting into the to or bcc adress fields the lines in the copied text are separated with spaces instead of commas as it was in previous versions of kmail. This means i cannot copy a column of email addresses from a spreadsheet and add them all as recipients in a mail in kmail. Because Kmail will understand the text as one long email address." The problem is still present in v5.2.3.
oocalc exports text with space as separator no ?
From the test I created, yes it does.
As it's exported with space separator we can't parse it as multi email :(
Ok so I tested once again, and if you copy then paste an email list from LibreOffice into a text editor, you do get newlines between each emails, like so : ``` foo@example.com bar@example.com "Foobar" <foobar@example.com> ``` I think those newlines should do the trick, right?
I tried again with Kmail XX and the following text: ``` foo@example.com bar@example.com "Foobar foo" <foobar@example.com> ``` When pasted, the newlines are ignored and all the text is used as is in a single 'To:' field. If you then select all the text in that field and paste it in a text editor, I then see the newlines again! The newlines could be used to 'explode' the email recipients.
Kmail was v5.9.3 above.
The problem is the separator. Add commas and it works