How can I send bulk email in ERPNext CRM?

1

How can I send bulk email in ERPNext CRM?

Email Account Issue : The email account settings are configured, but the recipients are not receiving the emails.

2

Can anyone please help on this?

3

@ShilpaShivan

Can you do a test email and check if it is reaching anyone’s email

Build - Communication Log - Add Communication

Post a picture here of the log

Also have you added the email account to the administrator or system user?

4

@asieftejani Thanks for the Response.

I have tested by sending an email, but the recipients are not receiving it.

In the communication log , Status is showing sent.

image
image1050×596 18.4 KB

Email Account Configuration for Sender mail Address :

image
image580×210 9.68 KB

image
image1064×696 51.8 KB

In Email Queue I can see the error below:

Error

Traceback (most recent call last):
  File "apps/frappe/frappe/email/smtp.py", line 87, in session
    res = _session.login(str(self.login or ""), str(self.password or ""))
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/smtplib.py", line 750, in login
    raise last_exception
  File "/usr/lib/python3.12/smtplib.py", line 739, in login
    (code, resp) = self.auth(
                   ^^^^^^^^^^
  File "/usr/lib/python3.12/smtplib.py", line 662, in auth
    raise SMTPAuthenticationError(code, resp)
smtplib.SMTPAuthenticationError: (535, b'Authentication Failed')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 181, in send
    ctx.smtp_server.session.sendmail(
    ^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/smtp.py", line 98, in session
    self.throw_invalid_credentials_exception(email_account=self.email_account)
  File "apps/frappe/frappe/email/smtp.py", line 140, in throw_invalid_credentials_exception
    frappe.throw(
  File "apps/frappe/frappe/__init__.py", line 609, in throw
    msgprint(
  File "apps/frappe/frappe/__init__.py", line 574, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 525, in _raise_exception
    raise exc
frappe.email.smtp.InvalidEmailCredentials: Please check your email login credentials. smtplib.SMTPAuthenticationError: (535, b'Authentication Failed')

This is the roles and permission added for this email id:

image
image1210×859 83.8 KB

Could you please check the above details and help me resolve this issue?

5

Which password are you using in setting up email account

You supposed to use Google app password for Google accounts from their you can generate the password and set it in the email account

6

It is my Company Mail Id . And we are using ZOHO mail.

7

So i enabled MFA by Login to Zoho Account and followed these steps

MFA enabled – requirement to generate App Password

OneAuth approval process

Clicked on Generate App Password, 12 digit password displayed I pasted it in my email account

Tested sending mail, still not receiving mail

image
image1105×210 7.97 KB

Error :

Traceback (most recent call last):
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 176, in send
    message = ctx.build_message(recipient.recipient)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 324, in build_message
    message = self.include_attachments(message)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 401, in include_attachments
    print_format_file = frappe.attach_print(**attachment)
                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 2169, in attach_print
    else get_print(doctype, name, **kwargs)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/print_utils.py", line 92, in get_print
    return get_pdf(html, options=pdf_options, output=output)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/pdf.py", line 94, in get_pdf
    filedata = pdfkit.from_string(html, options=options or {}, verbose=True)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.12/site-packages/pdfkit/api.py", line 75, in from_string
    return r.to_pdf(output_path)
           ^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.12/site-packages/pdfkit/pdfkit.py", line 201, in to_pdf
    self.handle_error(exit_code, stderr)
  File "env/lib/python3.12/site-packages/pdfkit/pdfkit.py", line 155, in handle_error
    raise IOError('wkhtmltopdf reported an error:\n' + stderr)
OSError: wkhtmltopdf reported an error:
The switch --print-media-type, is not support using unpatched qt, and will be ignored.The switch --header-html, is not support using unpatched qt, and will be ignored.The switch --footer-html, is not support using unpatched qt, and will be ignored.The switch --disable-smart-shrinking, is not support using unpatched qt, and will be ignored.Exit with code 1 due to network error: HostNotFoundError
8

Right you get different error so try to read at the error and it’s coming in printing issues

9

@ShilpaShivan

Try this bench command
bench --site sitename set-config host_name “https://example.com”

Hope it helps

10

Please DM 0505862091