Unicode Support about mailmerge HOT 7 CLOSED

$ mailmerge --version
mailmerge, version 1.7.6
$ mailmerge 
>>> message 0
TO: [email protected]
SUBJECT: Foo
FROM: Brian Exelbierd <[email protected]>

Hi Kristýna,


>>> sent message 0 DRY RUN
>>> Limit was 1 messages.  To remove the limit, use the --no-limit option.
>>> This was a dry run.  To send messages, use the --no-dry-run option.
$ file mailmerge_template.txt mailmerge_database.csv 
mailmerge_template.txt: ASCII text
mailmerge_database.csv: UTF-8 Unicode text
$ cat mailmerge_template.txt 
TO: {{Email}}
SUBJECT: Foo
FROM: Brian Exelbierd <[email protected]>

Hi {{Name}},

$ cat mailmerge_database.csv 
Name,Email
Kristýna,[email protected]

$ file mailmerge_template.txt
mailmerge_template.txt: ASCII text
$ file mailmerge_database.csv
mailmerge_database.csv: UTF-8 Unicode text
$ python --version
Python 3.5.2
$ mailmerge --version
mailmerge, version 1.7.7
$ mailmerge
>>> message 0
TO: [email protected]
SUBJECT: Testing mailmerge UTF8 support
FROM: [email protected]
Content-Type: text/plain; charset="UTF-8"

Hi, Séan


>>> sent message 0 DRY RUN
>>> Limit was 1 messages.  To remove the limit, use the --no-limit option.
>>> This was a dry run.  To send messages, use the --no-dry-run option.
$ mailmerge --no-dry-run
>>> message 0
TO: [email protected]
SUBJECT: Testing mailmerge UTF8 support
FROM: [email protected]
Content-Type: text/plain; charset="UTF-8"

Hi, Séan


>>> Read SMTP server configuration from mailmerge_server.conf
>>>   host = smtp.gmail.com
>>>   port = 465
>>>   username = [email protected]
>>>   security = SSL/TLS
>>> password for [email protected] on smtp.gmail.com:
Traceback (most recent call last):
  File "/path/to/mailmerge/env/bin/mailmerge", line 9, in <module>
    load_entry_point('mailmerge==1.7.7', 'console_scripts', 'mailmerge')()
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/mailmerge/__main__.py", line 45, in cli
    config_filename=config_filename,
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/mailmerge/api.py", line 232, in main
    sendmail(message, config_filename)
  File "/path/to/mailmerge/env/lib/python3.5/site-packages/mailmerge/api.py", line 94, in sendmail
    message.as_string(),
  File "/usr/lib/python3.5/smtplib.py", line 850, in sendmail
    msg = _fix_eols(msg).encode('ascii')
UnicodeEncodeError: 'ascii' codec can't encode character '\xe9' in position 160: ordinal not in range(128)
$ cat mailmerge_template.txt
TO: [email protected]
SUBJECT: Testing mailmerge UTF8 support
FROM: [email protected]
Content-Type: text/plain; charset="UTF-8"

Hi, {{name}}

$ cat mailmerge_database.csv
email,name,number
[email protected],"Séan",17
[email protected],"Bob",42