Selected Answer
You need to go through Microsoft Outlook. You can setup outlook to work with gmail accounts.
We currently have 3 macros on the site that might help you:
Email Current Workbook & or Other Attachments
Email List of People from Excel Using a Macro
Send Emails through Outlook using Email Addresses from Excel and text from Word
I think this macro might be the one that you are looking for:
Sub Send_Email_to_List()
Dim OL As Object, MailSendItem As Object
Dim MsgTxt As String
Set OL = CreateObject("Outlook.Application")
For Each xCell In ActiveSheet.Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
user_email = xCell.Value
user_subject = "Subject Line for the Email"
user_msg = Cells(xCell.Row, 2).Value
Set MailSendItem = OL.CreateItem(olMailItem)
With MailSendItem
.Subject = user_subject
.Body = user_msg
.To = user_email
.Send
End With
Next xCell
Set OL = Nothing
End Sub
It's from the second link above, which provides more information on the macro.