Mass email a column of email addresses?

**bmblack** · 12-29-2008, 10:10 AM

I have a column in my excel spreadsheet with many email addresses in it. I would ideally like to be able to send out a mass email to every email address in that column.

Is there a way to create a link or something so all i have to do is click it and an outlook email will pop up with the entire column of email addresses already populated in the "To..." field?

If that isn't an option, is there a way to simply create a new cell at the very top of my document which will display every email address in the column (seperated by semi-colons ; ), so all i have to do is click on the cell and copy then paste in the "To..." field in outlook?

**Rahul Nagar** · 12-29-2008, 10:54 AM

Hello Sir,

I think this help

Create an Excel Spreadsheet

1. Open Microsoft Excel.
2. In cell A1, enter the text "email"
3. In cell A2, enter a valid email address (suggestion: your own email address)
4. In cell A3, enter another valid email address (this can again be your own email address)
5. Highlight all three of these cells
6. Select the menu item "Insert->Name->Define" (this may be different for versions before Microsoft Office 2000). A dialog box will appear.
7. Enter the name of the range, "customer", then click "OK".

8. Save the spreadsheet in an easy to find location, such as "C:\tmp" and name the file "example.xls".

Create an ODBC DSN

1. Create an ODBC DSN for Excel named "abcd". For instructions on creating an ODBC DSN, click here.

Create a batch file

1. In the same directory that you saved the Excel spreadsheet, create a batch file named "example.bat". For instructions on creating a batch file, click here.
2. Cut-and-Paste the following text into your "abcd.bat" batch file:

"c:\program files\netmailbot\netmailbot.exe" -to "[email protected]" -server "mail.changeme.com" -dsn "DSN=example" -dbtable "customer" -dbemailcolumn "email" -dbuseaddressee "to" -recipientlimit 1 -from "[email protected]" -subject "test" -logfile "logfile.txt" -debug

**alivallo** · 09-30-2015, 02:40 PM

There are two easy ways to do this:

method 1: 'column A' has the email addresses, you place a "semicolon" in 'column B'; then =Concatenate columns A and B into a third column. Copy and paste into Outlook. your done.

method 2: you may export only the Email address column of your excel sheet to .CSV format "NO Header Row" just email addresses;
open in "Notepad";
and 'find/replace' all the 'commas' with 'semicolons'; copy and paste into Outlook.
Note: if you setup outlook to separate email address by comma instead of semi-colon you can skip the last step and copy/paste right out of your CSV file in notepad.

EDIT: didn't read the post fully; using method 1; you create a Macro to do this for you; then paste into Outlook; takes 3 clicks if your excel sheet dump is the same format every time.

Or go one step further and edit this macro in VB developer mode to Email to all addresses in 'Column A'