#HOW TO CREATE OUTLOOK EMAIL GROUP FROM EXCEL LIST HOW TO#

#HOW TO CREATE OUTLOOK EMAIL GROUP FROM EXCEL LIST HOW TO#

In one of my previous articles I described how to create a message based on a template. The Application class has the CreateItemFromTemplate method for this task. We can use a template for creating a new distribution list. A newly created distribution list is always created in the default Contacts folder regardless of the Items collection we use (frankly speaking, the collection may come from any folder).ģ. The Items class provides the Add method which does the job. This method accepts a constant from the OlItemType enumeration and returns a newly created distribution list.Ģ. The simplest way is to use the CreateItem method of the Application class.

The similar steps are used for creating distribution list items in Outlook:ġ. Some time ago we discussed how to create a new contact item programmatically. The process of creating Outlook distribution lists is fairly simple. They are available to everyone connected to the Exchange server. If you use an Exchange server in the profile, the Global Address List can contain global distribution lists. Note, you can send them to others if needed. Distribution lists are stored in the Contacts folder too (I mean personal distribution lists). There is no difference between creating a single contact item or a distribution list item. Let’s consider in depth how to create a distribution list in your profile programmatically with VSTO and Add-in Express for Office and. Using distribution lists users can set the TO, CC and BCC fields and send e-mails as they normally do. The distribution list represents a group of contacts that are related in some way. The Outlook Object Model provides the DistListItem class exactly for this task. Your friends might be okay with you contacting them by email, but they likely don’t want their contact information shared with everyone you send mass emails to.Sometimes Outlook users need to send their e-mails to the same recipients.

Why Would You Hide the Names in a Contact Group? We’ll be showing you how to hide the names of the recipients in a contact group, but the same steps work for distribution lists. If you don’t have O365 and are using a stand-alone version of Office without web apps, you might still have distribution lists available to you. RELATED: What's the Difference Between Office 365 and Office 2016?

If you think this sounds exactly like a distribution list, you’d be right, with one notable exception: By default, distribution lists (and O365 Groups) appear in your organization’s global address book for everyone to see. Instead of having to add each of them individually to an email, you can email the group name, and everyone in that group will be added as a recipient.

Contact Groups: These are a bunch of email addresses added to a group.

These are great for small project teams, organizing your local theater group’s rehearsals, or any other scenario where you need quick and simple collaboration tools.

O365 Groups: Designed for on-the-fly collaboration among a group of people, these groups include a shared mailbox, calendar, file store, Planner, and OneNote Notebook.

In Office 365 (O365), Microsoft’s subscription version of Office, two separate groups have replaced distribution lists:

How to create outlook email group from excel list