(You’ll need a list of addresses it’s most common to put them in column A.) This data can be your contacts’ names, company names, or any other details. How to Send a Mass Email with Excel - The More Complicated WayĪ mail merge automatically fetches data from a spreadsheet (or other data source) and inserts it into an email template.How to Send Mass Emails with Excel - The Easier Way.(Click on the links below to jump to a specific section) How to Send Mass Email from Excel: Table of Contents I’ll also go into detail about common merge issues with MS Excel, as well as the fixes for those problems. In this article, I’ll show you how to perform a mail merge using an Excel spreadsheet to send your personalized mass email messages whether they’re cold email, email marketing, or any other type of email campaign. More good news: There’s a simple solution to send your email blast which we’ll cover in this article. (And in complex cases, you might even need to bring Excel VBA and at least one VBA macro into the equation.) The bad news? It can get a bit convoluted and requires bringing Microsoft Word into the equation when you’re sending through Microsoft Outlook. We’ve got good news and bad news on how to send mass email from Excel.