Mail Merge Auto Email VBA - Multiple CCs.

Hi,
I have an excel macro / spreadsheet that i use to mass emailing people. It has been re-purposed over the years for various functions, so, to be honest, there is lots of stuff in it that probably is not relevant to what I need now. I'm not the creator, though I've had to make some tweaks over the years.. but, i'm not a programmer.

So, the script will take data from the tab "RFCs Not Closed", compile unique spreadsheets for each name in Column F, then create the email, attach the spreadsheet with the rows of data matching on Column F.
So, in the attached example, I will get 1 email, addressed to jacob two-two, it will have a spreadsheet with the columns/rows of data that you can see on the first tab. It will email the email address in Column G.

What I'm trying to do, is get it to CC the names in Column I, for every row of data. Right now, it will CC the first name it comes across "per name" in Column F. So, if I have 5 managers... I'll get 5 spreadsheets, with 5 emails. If a manager has say 10 rows of data, even if the CC name has 10 unique names for that manager, it will pick only the first one, and CC it. Hopefully this is making sense what I'm saying.

Essentially, i want rows of data for the manager, and for it to CC all the users as well so they are aware the manager is being emailed (its for following up with outstanding training).
I've attached the file (or hopefully I've attached it!)

Can anyone help? Is this possible to do without having to re-write the whole script? The coding is on the object "sheet1 (RFCs Not Closed)". I'm sorry if this is a bit too much info provided, but I'm just not sure which function that needs to be modified.

Rilly

See if this works for you.

I posted the whole sub so you can just copy and paste.

Since the CC is just a text string, I build a unique list using a Collection, build a concatenated string, then post that to the Email sheet.

Please Login or Register  to view this content.

So, tell me how you operate this code.

Which ones do you run to start the process?

Should the code generate all ten manager's email in one run?