Sending macro emails using excel: Send emails with their passwords.

Hello everybody! I am very new to excel programming. I don't usually program using excel or vba but I have to for a project.

I have to find a way to send macro emails to members with a custom message with to their emails in this excel spreadsheet with their corresponding passwords in the next column. I want to use vba and I have Windows Mail.

Attached is a sample form of the members.