1

I'm using CiviCRM with Wordpress and have around 1500 contacts.

I have 3 groups with around 120 contacts in each group which I use for mailings.

I sent a bulk email to one of the groups then around 10 minutes later all 3 groups had 550 contacts in them.

When I look in the Groups tab of one of the newly added contacts I can see that they were added to all 3 groups at the same time and says "Added (by Admin)".

Has anyone come across this before or have any idea why it might have happened?

Is there a way to find contacts based on date added to a group so I can search for them and remove them from the groups?

Thanks

2

From UI i don't think there is any way you can get history of contact being added to group. If you have hands of experience in writing sql statements than you can use civicrm_subscription_history table in Civicrm to track down about all history of contact added to group by dates.

| improve this answer | |
  • Thank you. I found them using: SELECT * FROM civicrm_subscription_history WHERE date BETWEEN '2020-01-02 14:30:00' AND '2020-01-02 15:00:00' but now I think I need to delete them from that table and from the civicrm_group_contact table? – Slingshot Design Feb 3 at 21:26
  • can you mark this as answered if you feel the post was helpful – Pradeep Nayak Feb 3 at 21:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.