Sending multiple emails with a different subject line for each

[finding_dory]

Hi experts, I really need help with writing vba codes as I do not have any programming background at all..

I need a macro that will help me send multiple emails:

- for each individual email sent, the subject line is customised

- the 'To' contacts stay the same for all the emails but the 'Bcc' contacts will change according to email addresses down the column

- upon clicking a button, several outlook windows will appear, so that i can send via outlook with the email message and recipients contacts already filled in

- i currently have 2 columns: column 'C' for 'bcc' contacts and 'D' for the personalised subject line
- a template email body on sheet2 range B3

Thank you in advance and i really hope you guys can help me with the code

 

[Kenneth Hobson]

Welcome to the forum! That is a very involved project and especially so for a VBA new beginner.

With a few tweaks, you can use something like the Main() sub in the mMain module in the XLSM file. It attaches a PDF of the Invoice. The XLSX file is the template that is filled as an invoice for each row in the XLSM file.
https://www.dropbox.com/s/7kpeqi8p2udzte4/InvoiceTemplate.zip?dl=0

Change the .Send to .Display as commented.