def make_sertifyMe(id, sp1, sp2, xfile, doemail):
data = pd.read_excel(xfile)
# name_list = data["Name"].tolist()
# email_list = data["Email"].tolist()
# Make certificate and check if it was successful
if id == '03':
for i in data.iloc:
filename = Draw.Certi03(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
elif id == '04':
for i in data.iloc:
filename = Draw.Certi04(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
elif id == '05':
for i in data.iloc:
filename = Draw.Certi05(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
elif id == '06':
for i in data.iloc:
filename = Draw.Certi06(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
elif id == '07':
for i in data.iloc:
filename = Draw.Certi07(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
elif id == '08':
for i in data.iloc:
filename = Draw.Certi08(i[0], sp1, sp2)
if doemail:
EmailDo(filename)
