Answers.Body: <p>I think I found it: Administer &gt; CiviMail &gt; CiviMail Component Settings &gt; &quot;Enable CiviMail to create activities on delivery&quot; is checked in our project.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-30T11:52:33.703Z
Answers.LastActivityDate: 2020-10-30T11:52:33.703Z
Answers.UserDisplayName: Tobias Krause
Body: <p>We are facing a huge database growth as we send newsletters to a growing recipients list. The newsletter is sent with CiviCRM Mail to a contacts group. I realized that the biggest table in our project is the civicrm_activity_contact table - and I am quite sure that most of the entries are those entries generated when a contact received the newsletter.</p>
  <p>As there is a tab &quot;Mailings&quot; for each contact where all these newsletter mailings are listed I wonder why there are activities created additionally? Is there a need for these activities? Can I turn off activity creation for mass mailings somewhere?</p>
  
Tags: <civimail><activities><mailing>
Title: Avoid an activity entry for each recipient contact of a mass mailing
ThreadText: # Avoid an activity entry for each recipient contact of a mass mailing
  
  (Asked by: username_0 on 2020-10-30)
  
  We are facing a huge database growth as we send newsletters to a growing recipients list. The newsletter is sent with CiviCRM Mail to a contacts group. I realized that the biggest table in our project is the civicrm\_activity\_contact table - and I am quite sure that most of the entries are those entries generated when a contact received the newsletter.
  
  As there is a tab "Mailings" for each contact where all these newsletter mailings are listed I wonder why there are activities created additionally? Is there a need for these activities? Can I turn off activity creation for mass mailings somewhere?
  
  **Tags:** civimail, activities, mailing
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-10-30. Score: 3
  
  I think I found it: Administer > CiviMail > CiviMail Component Settings > "Enable CiviMail to create activities on delivery" is checked in our project.
  
  
  ---
  
  