sequence item 0: expected string, tuple found

Question

(user_mail, ','.join(recipient), mail.as_string())

The above code produces error of expected string but tuple found. How should I fix this? Any solution?

recipient = [] db = MySQLdb.connect(host = "', user = ''', paswd=''', db=''') cursor = db.cursor() cursor.execute('select email from user where email is not null') rows=cursor.fetchall() for item in rows: recipient.append(item) — Erica Elsie Mi-in, Jun 17 '17 at 19:40
I am asking for the code that could explain the problem and help us to find the solution. You can post the code that sends email like smtplib.login and other codes. — Arpit Solanki, Jun 17 '17 at 19:43
mailServer.sendMail(user_mail, ','.join(recipient), mail.as_string()) will this do? it says this line is having problem. I try to read emails from database and make python to send email with attachment to them. — Erica Elsie Mi-in, Jun 17 '17 at 19:47

Arpit Solanki · Answer 1 · 2017-06-17T20:23:01.463

0

You must specify recipients in a string . Below is an example you can specify recipients like this.

user_email = "someone@example.com"
recipients =  ["email1, email2, email3"]

edited Jun 17 '17 at 20:23

answered Jun 17 '17 at 19:54

Arpit Solanki

I tried it and it says typeError: sequence item 3: expected string, tuple found – Erica Elsie Mi-in Jun 17 '17 at 20:11
Try the edit I hope that this works. I did use lists and it worked fine but I don't know why it's not working in your case – Arpit Solanki Jun 17 '17 at 20:15
Attribute error : str object has no attribute append – Erica Elsie Mi-in Jun 17 '17 at 20:34
The one that I commented above, recipient.append(item) – Erica Elsie Mi-in Jun 17 '17 at 20:43
use `recipients = [item for item in recipient]` – Arpit Solanki Jun 17 '17 at 20:51
Invalid syntax came out for the use recipients = [item for item in recipient] – Erica Elsie Mi-in Jun 18 '17 at 01:29

1 Answers1