• Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
Menu
  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
  • Latest News
    Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads
  • Latest News
    Excel To VCF Converter 1.1 – Excel To Vcard – 68,000 Downloads
  • Latest News
    Extract Web Page with Tables – Parse HTML Table – Data Mining Tool
  • Latest News
    Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook
  • Latest News
    Web Scraping – Extract Data from Website – To Excel VBA
  • Latest News
    VCF To Excel Converter – Open VCF File – Free 28,000+ Downloads
  • Latest News
    Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
  • Latest News
    Excel VBA – Import Data from Another Workbook – Macro to Query Excel
  • Latest News
    How to Telnet from Excel & Autorun Commands
  • Latest News
    Excel VBA – FTP Transfer – Files Download Upload
  • Latest News
    Microsoft Office – Communicator API – Verify Availability Status
  • Latest News
    Excel IP Address Lookup – Bulk GeoIP Lookup
  • Latest News
    Extract URL Links from Sitemap.xml file using Excel
  • Latest News
    Trace Lost Phone – Even Without Internet – Using SMS
  • Latest News
    Universal VCF to Excel and Excel to Vcard Converter
  • Latest News
    Download Facebook Videos – How To Get YouTube Video Downloader?
  • Latest News
    Block Game Requests On Facebook & Candy Crush Invites
  • Latest News
    How to Get stock prices in Excel? – Best Live Stock Ticker
  • Latest News
    How to Get Historical Stock Quotes In Excel – Google Finance
  • Latest News
    JSON Parser – Convert JSON To CSV – Excel VBA Macro
  • Latest News
    How To Screen Record – in IOS, iPhone, Android, Windows, Mac ?
  • Latest News
    How To Remove Duplicate Values in Excel, Google Sheets?
  • Latest News
    Best Bitcoin Trading Platforms – Cryptocurrency Market
  • Latest News
    Lock System at Scheduled Time with Excel
  • Latest News
    How to control Facebook Addiction? & Whatsapp Addcition
  • Latest News
    2018 – Hack Whatsapp Friends – Status Photos
  • Latest News
    Making SORT More Simple and Faster in Excel with Advanced Options
  • Latest News
    WordPress – Recent Posts Widget with Thumbnail – Without Plugins
  • Latest News
    Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
  • Latest News
    Display Related Posts with Thumbnails in WordPress without Plugins
  • Latest News
    Post to Facebook Timeline through Email
  • Latest News
    100 CryptoCurrency Price – Ticker in Excel – Using VBA
  • Latest News
    Engineering Unit Converter Download – Excel Table – Feet To Meters
  • Latest News
    Android ICS File Viewer – Calendar file View in Exce;
  • Latest News
    Download – Backup Facebook Twitter Gplus Linkedin – Data To PC
  • Latest News
    How to remove #n/a in Excel? – Fixing Vlookup #n/a
  • Latest News
    #NoForwardsDay – New WhatsApp Texting Pattern that Would Make You Go Crazy
  • Latest News
    Sudoku Excel Download – Puzzle Solver – Free Game Help
  • Latest News
    Top 4 Whatsapp Tips and Tricks You Didn’t know Existed
  • Latest News
    Mortgage Calculator – Loan EMI Scheduler
  • Latest News
    Learn How To Code JavaScript in VBA
  • Latest News
    How To Open VCF File – Online VCF Viewers – 4 Easy Ways
  • Latest News
    How To Block Unwanted Text Messages in Iphone?
  • Latest News
    How To Scrap A Website Keywords? – Keyword Scraping Excel
  • Latest News
    Login to Facebook, Twitter, Google+ in IE from Excel
  • Latest News
    Excel Instant Messenger – Microsoft Office Communicator API Library
  • Latest News
    Skyrocket Website Traffic With Reddit
  • Latest News
    Excel Games Free Download – 2048 Tile Game
  • Latest News
    How to Speed Up Google Chrome
  • Latest News
    VBA Code – Create Index of Worksheets – with Links to each Sheet

This Tiny VBA Can Send Email to All contacts in Your Outlook

  • How to Send email to all contacts in Outlook?

    Use one of the following methods to send Email blast from Outlook. i.e., mass email in Outlook to a large audience.

    • Outlook Create Distribution List – Create Email group in Outlook
    • Using VBA Code – Send mass email Outlook

    These 2 are not the only possible methods to send mass email. There can be other possible methods and software products also to do this. Here, we have explained 2 possible methods (one manual & other Automation using VBA) to do this. Lets start with the manual method.

    How to Send Mass email?

    1. Outlook Create Distribution List

    To create email distribution list in Outlook follow the below instruction.

    1. Click on drop down near “New” in Outlook menu.
    2. Select “Distribution List” (or Keyboard shortcut – “Ctrl + Shift + L”).
    3. In the new window, fill ‘Name’ field & then click ‘Select Members’.
    4. Choose the “Address Book” name from the dropdown list in Popup window.
    5. Select all members in the contacts list. (Choose first contact in list & press shift + last contact).
    6. Click on “Members” button at to add contacts to distribution list.
    7. Repeat steps 4 – 5, if there is more than one Address Book.
    8. Click ‘Ok’, once all contacts are selected and added to Members field

    This will create distribution list in Outlook & save it as a new contact entry. You can see the new entry in Outlook Contacts with the name that you entered in Step 3. Let’s see how to send a mass email in Outlook with this email distribution list.

    Also Read: Check If Outlook is Running - then Launch Outlook app - vba code

    2. Send Email Blast from Outlook – Manual Method

    Create a new Outlook Email Item (Keyboard shortcut – ‘Ctrl + Shift + M’) & then click on ‘To’, ‘CC’ or ‘Bcc’ button. It will open a popup window to select Names from Contacts. Double click on “All Contacts” (or the name entered while creating distribution list) & click ‘Ok’.

    This email group list is now added to the new email item. Fill subject, email content & click ‘Send’. This will send the email to all the email addresses added to distribution list.

    Also Read: Excel VBA - Convert Column Number to English Alphabet Letter

    How to Send a Mass Email in Outlook using VBA?

    Use this Tiny VBA code that will automatically pick all contacts from Outlook and send batch email to all.

    VBA Outlook Send Mass Email
    Visual Basic
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    'Outlook VBA to Send Mass email - Officetricks.com
    Sub Send_Mass_Email_To_All_Contacts_In_Outlook()
        'Define & Create Objects to get contact list & to create new Outlook email
        Dim objItem, objEmail, toList As String
        Set objOutlookApp = New Outlook.Application
        Set objMAPINamespace = objOutlookApp.GetNamespace("MAPI")
        Set objContactFolder = objMAPINamespace.GetDefaultFolder(olFolderContacts)
        Set objContacts = objContactFolder.Items
        
        'Creating Email address distribution list or Email Group
        For Each objItem In objContacts
            If TypeName(objItem) = "ContactItem" Then
                toList = toList & objItem.Email1Address & ";"
            End If
        Next
        
        'Send Email Blast from Outlook
        Set objEmail = objOutlookApp.CreateItem(0)
                With objEmail
                    .To = ""
                    .CC = ""
                    .BCC = toList
                    .Subject = "Mass Email in Outlook Sample Subject"
                    .Body = "Nothing, Just Testing my 'how to send mass email in outlook' program"
                    .Display 'or just put .Send to directly send the mail instead of display
            End With
    End Sub


    Also this is a good stating place to learn how VBA create email from Outlook. These VBA create email code or sending email to distribution list methods are all very useful if you have to send Outlook mass email to promote you business, market a product, organization level information messages or if you are job seeker, it will be useful to send resume to big list of companies.

    Author: Kumarapush

    Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.

    View all posts by Kumarapush | Website


    Previous Post: Palindrome program in C & VBA
    Next Post: Send Email from Excel with Attachment using vba


Post Categories
Popular Posts
Export Outlook Emails To Excel...
Excel To VCF Converter 1.1 –...
Extract Web Page with Tables –...
Send Mass Email from Excel VBA...
VCF To Excel Converter –...
Web Scraping – Extract Data...
Print Screen Automation –...
Excel VBA – Import Data from...
How to Telnet from Excel &...
Microsoft Office – Communicator...
Excel VBA – FTP Transfer...
Excel IP Address Lookup –...
Recent Posts
Enable Insert button in Excel greyed disabled show
Excel Insert Button is Disabled...
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates
Excel VBA - Find String in Range...
Excel VBA Convert Amount in Numbers to Words US Dollar Million Indian Rupee Lakhs Crores finance
Excel VBA Convert - Amount (Numbers)...
Excel VBA Code Get Names of All open workbook path Loop through
Excel VBA - Loop Through All Open...
Name Numerology Lucky Number Calculator Baby names Business name
Name Numerology Calculator - Lucky...
Similar Pages
  • Excel VBA Convert Amount in Numbers to Words US Dollar Million Indian Rupee Lakhs Crores finance
    Excel VBA Convert – Amount...
  • Excel VBA Code Get Names of All open workbook path Loop through
    Excel VBA – Loop Through All...
  • Name Numerology Lucky Number Calculator Baby names Business name
    Name Numerology Calculator –...
  • How To type Subscript in Excel Superscript strikethrough underline font
    How To Type Subscript in Excel –...
  • Excel VBA Merge Cells Unmerge Range Selection objects
    Excel VBA – Merge Cells –...
  • Excel VBA Convert Column Letter Alphabet to Number
    Excel VBA – Convert Column...
Popular Tags
  • Email Marketing Block Apps in FaceBook Task Manager print screen VCF HTML Table Import Data Candy Crush Outlook Record Macro android app development SEO Convert URL to IP HTML/ Javascript QR Code Generation VCARD Timer in Excel Countif Google+ bitcoin vba color index vba color codes Data Mining Android social media Twitter bulk email Google Adsense Tips Excel VBA Calendar in Excel Excel Macro WhatsApp Facebook mass email outlook vba Wordpress
FREE Tech Updates

Home

  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling

Trending Topics

    • Learn How to Access WhatsApp in Web
    • Compare Data In Two Excel Sheets
    • Find IP Address Location – GeoIP Lookup
    • Lock a Folder In Windows Using This Simple Excel Macro Trick
    • Download Free Tool to Convert VCF Contacts to Excel

Join Us

Copyright © 2018 OfficeTricks.com