I've spent the last couple hours trying to find an answer in one of the forums regarding how to do a mail merge with a unique subject for each email from a column in Excel with no luck. I am new to VBA but understand some of the coding language used.

Simply put I would like to be able to do the following:

- Create an email using a list in excel (ie. name, address, etc.)
- CC multiple recipients (ie. email 1, email 2, email 3, email 4, etc)
- Use a subject found in a column in excel so that each email has a unique subject (I have specific subjects for each recipient so that they don't feel like they are just another email recipient)
- Attach a different PDF for each email (file path found in excel column)

PLEASE do not reference any downloads on random websites. I am looking for pure VBA code that I can utilize and modify accordingly if at all possible based on the column names that I have in my spreadsheet. Any help would be very much appreciated!

Thanks,

Aseagz15