In a previous post we saw how to send emails from Excel via Outlook and from a Microsoft email account. We could use the same method to send email with Gmail by adding the Gmail account to Outlook and specifying to send using that account. However, if we don’t want to use Outlook at all, we can also send an email from Excel via a Gmail account using the Collaboration Data Objects (CDO) API for Windows. In this post we see a macro that sends an email from Excel using a Gmail account.
In a previous post, we have seen how to send an
email from Excel (via Outlook) using VBA macros. We can add as many recipients
as needed separated by a semi-colon when sending one email. However, if we want
to send separate emails to each recipient, we need to loop through the list of
recipient emails and send an email to each of them individually. In this post,
we see how to send multiple emails to recipients listed in a worksheet in
Excel. We can choose to send the same or a different subject, body, or attachments
to each recipient.
We can integrate Excel with other Microsoft Office applications using VBA. In this post we are going to see how to send an email from Excel (via Outlook) using VBA macros. You need to have Microsoft Outlook installed and configured with a mail account for the macro to work.
