How to send list value in a single mail in python?

Question

I have a list in which there are 2 values. I want to send mail with that list value but every time it is sending a separate mail for each value.

List is:-

file_list = ['D:/Users/SPate233/Downloads/NS dashboard/sql_query\\Book1.csv', 'D:/Users/SPate233/Downloads/NS dashboard/sql_query\\Book2.csv']

Sample code:-

                 for names in file_list:
                    body = "Hi Team, \n\n NS_Dashboard_FieldExecution script failed due to some reason. " \
                            "\n Please check the attached log file.\n Empty Files :- \n %s" %names  + \
                            "\n\n Thanks & Regards, \n NS_Dashboard_FieldExecution Team"
                    emailstr = "echo '{0}' | /bin/mail -a {1} -s '{2}' '{3}'".format(body, msg_tran, sub, receiver)
                    os.system(emailstr)

Output:-

I want a single mail with the name of both the value of the list. like this:-

Hi Team, 

 NS_Dashboard_FieldExecution script failed due to some reason. 
 Please check the attached log file.
 Empty Files :- 
 D:/Users/SPate233/Downloads/NS dashboard/sql_query\\Book1.csv
 D:/Users/SPate233/Downloads/NS dashboard/sql_query\\Book2.csv

 Thanks & Regards, 
 NS_Dashboard_FieldExecution Team

safepost · Accepted Answer · 2019-04-04 12:06:05Z

1

Because you need to build your body with loop, not looping on the entire mail construction and sending process

Something like this :

body = "Hi Team, \n\n NS_Dashboard_FieldExecution script failed due to some reason. " \
                            "\n Please check the attached log file.\n Empty Files :- \n %s"
for names in file_list:
       body += %names  
body += "\n\n Thanks & Regards, \n NS_Dashboard_FieldExecution Team"
emailstr = "echo '{0}' | /bin/mail -a {1} -s '{2}' '{3}'".format(body, msg_tran, sub, receiver)
os.system(emailstr)

answered Apr 4, 2019 at 12:06

safepost

1752 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Umesh · Accepted Answer · 2019-04-04 12:14:34Z

1

You are looping on file_names. If you want to send all file_names in one go, then stop looping on file_names file_names = " \n ".join(file_list)

file_names = " \n ".join(file_list)

body = "Text %s Text" %names 
body = "Hi Team, \n\n NS_Dashboard_FieldExecution script failed due to some reason. " \
                            "\n Please check the attached log file.\n Empty Files :- \n %s" %file_names  + \
                            "\n\n Thanks & Regards, \n NS_Dashboard_FieldExecution Team"

emailstr = "echo '{0}' | /bin/mail -a {1} -s '{2}' '{3}'".format(body, msg_tran, sub, receiver)
                    os.system(emailstr)

edited Apr 4, 2019 at 12:14

answered Apr 4, 2019 at 12:08

Umesh

9715 silver badges12 bronze badges

Comments

Lucas · Accepted Answer · 2019-04-04 12:10:56Z

0

Rather then looping for each file, you can also convert the list into a string, use

% '\n'.join(file_list)

in place of % names and skip the loop.

answered Apr 4, 2019 at 12:10

Lucas

3951 silver badge11 bronze badges

Collectives™ on Stack Overflow

How to send list value in a single mail in python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related