Hi there,

I have not done any vba coding before and would like to shout out to the kind souls out there who are willing to share the VBA codes with me..

Below are what I would like to see in the email automation:

- Sheet 1: for me to enter all the email addresses i wanna Bcc to and their names in two columns
* i just want to send to an email address and Bcc to the rest of the contacts..

Sheet 2: for typing out the email subject line, body message and who i wanna send to/ cc/bcc etc.
* as i type in the cells, the coding will be updated too

- As i add in another new email contact, the coding will also be updated

- i want to attach the same attachment for all the email contacts

- a 'send email' button to be created in 'Sheet 2' and upon clicking, it opens up the outlook box and i can proceed to send via outlook

Really hope someone could show me the codes for the above, greatly appreciate all help!