I solved this. I used the following:
INSERT INTO weekly_summary_activities (email,campaign, admin_email, type, year, week, business_comp, project, activity, hours) SELECT email, campaign, admin_email, type, year, week, business_comp, project, activity, SUM(hours) FROM activity_log GROUP BY email, campaign, project, business_comp, activity
proof that an old dog can learn new tricks