How To Create A Distribution List In Outlook From An Excel Document

Here I provide the details of how to do it. Applies to: SAP BW 3. You can start with an existing PDF file, a Word or Excel file, or any other type of document. Access to this option is found on the List Field tab. You get a document from a colleague and you notice that each paragraph starts with a tab character. Type a name. Create the distribution list. Each cell is referenced by its coordinates of columns and rows, for example A1 is the cell located in column A and row 1; B7 is the cell in column B and row 7. How to create a contact group distribution list in outlook 2007 tech recipes. When you use this Outlook macro to complete the mail merge, you will be able to send from other email addresses, including a distribution group address in Exchange Global Address List or a shared mailbox. How to insert images into word document table - Duration: Excel, & Outlook - Office 365. How to use purchase order template. csv file format We can export Contacts from Outlook directly into. Made lots of changes and saved at least a few times. One of the requirements is that we have "distribution lists" so that when a user clicks on a link, it automatically opens Outlook with the "To:" field populated with all the team members names for a certain group. Extra steps are not required to save the routing slip information. Setting up a distribution mailing list in Outlook is easy. The area that is impacted the most is the Excel Ribbon. I have Windows XP and Microsoft Office 2007. For instance, if you set it as 1, the report will contain only one level: folder/subfolder. This chapter discusses using Outlook 2013 forms as part of a software solution for individual computing needs. Set Up Your To Do List in Excel. A document library is really just a special type of list. Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Click the plus + sign to expand the members. Open a new email. Managers who want to track projects and status automatically as they receive status e-mails. That’s the Orientation menu. Next, open GroupMail and go Groups/Import and select File Import. For exporting distribution list (contact group) as csv file and import it to Excel from Outlook, please do as follows. Process Excel Image. Is this possible?. As a bonus, you can add attachments to the messages as you merge. When you click the search button, PowerGREP will present you with a list of Excel spreadsheets and other files in which the text you entered in the search box was found. Please try again later. However, the rapid rise and fall of. How to insert images into word document table - Duration: Excel, & Outlook - Office 365. How to integrate Excel spreadsheet into MS Outlook calendar program 1. I would like to expand it so it actually creates the distribution lists automatically and either saves them in my Outlook contacts or. com wanted to send all of the files in a folder as email attachments, one attachment per message. Computerized spreadsheet tools, such as Excel, Numbers, 1-2-3 or Calc, are the best tools for creating a document distribution matrix template, but you can use any software that lets you create tables. Add Method in workbook1. Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Here I provide the details of how to do it. Follow Ty Anderson on Google+ , Facebook. Collaborate for free with an online version of Microsoft Excel. (See examples below) 1. If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. How to create an email distribution list of undisclosed recipients? By Healer · 7 years ago I often receive email messages showing "undisclosed recipients" as an addressee, no email address. Removing Unused Styles Got an older document that has a bunch of unused styles defined in it? You can get rid of those styles easily by using the short macro in this tip. So that when you want to send an email to a handful of contacts , or a thousand of them, the distributed list makes the job easy for you. csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a. I've used several of the concepts to create the programing I need. Select the cell. ExcelTemplates. After selecting the (contiguous) data range, in the Pivot Table Wizard's Layout option, drag Treatment to the Row variable area, and X to the Data area. I found your post on line. Hi patrickab thank you for your pointers on the shared workbooks being problematic, we have found this to be the case on and off ;) Anyway i checked out the calendarproject, its gives me some good insight on some VBA for sorting through a calendars etc, but back to my question really im looking for how to loop through Excel from an Outlook VBA and assign tasks and populate with data from cells. Wish to create scratch sheets as you work on the web? - Just bookmark this page. Create A Pop-up Alert When A Condition Is Reached In Excel - How does one create a popup or email alert when a condition - Free Excel Help. The welcome screen appears like this, now click on ‘ Browse’ option add XLS/XLSX file with software to convert them. Then, select Trust Center. Microsoft Access can import from Excel as well as export data to Excel. Tip 60: Restore the Outlook Desktop Icon Many of the Most Recently Used (MRU) lists in Outlook can be deleted by editing the registry. Add drop-down lists, custom icon sets, conditional formatting rules, etc. How to Use and Create Templates in Excel 2016 When you first started Excel, you saw the start screen with all the different types of templates pictured: When you use a template, all you have to do is replace the information in the worksheet with your own. Third party apps that have command line interfaces. ” Mr Excel has some good tips in this course on VBA Macros that you may want to look up. The dialog-box includes a count of the number of messages exported. To send a fax from Outlook, complete the following: ¶. Create the Excel table (Excel 2007) using Outlook field names to name an Excel table columns header: Subject Start Date Start Time End Date End Time Categories Description Location Priority etc. How to create a list of contacts/emails to send group emails to in Office 365 Mail Online. That way, everyone in the distribution list receives the same message and you save time. Allows the users to update SAP from within Excel, Outlook and Word. On the home tab of the ribbon, rx look for the alignment group. The document could be a flat database, such as a list of employees, a list of customers, or a record of students. I just wanted to let you all know that i successfully used some of the above content to make macro in excel that pulls all the list of emails in the to line of an 2013 outlook email message. It combines chat, docs, task lists, and spreadsheets in one app — making collaboration fast and easy. Create the distribution list. Excel VBA Macro > Create XLS to PDF & Email Posted on July 5, 2013 by Nick This is the Excel version of a previous post, Word VBA Macro > Create DOC to PDF & Email , to allow you to automatically generate a PDF attachment to a draft message in Outlook with a custom filename, from the click of a button in Excel. Distribution list is a grouping of email addresses collected under one name. How do I insert a link in Excel to an email within outlook. Got MS Excel? Need a simple map? A little known tool in older versions of Microsoft's Excel is the ability to create simple maps from tabular data. Add column headers to make up your to do list. Quit Outlook then open the registry Tip 28: Outlook's MRU lists Outlook 2016 won’t connect to Exchange 2007 Tip 1071: Auto Preview Email in Outlook 2013. You may need to create a specific template for this document. Search Through Microsoft Excel Speadsheets to Find Text, Keywords, Phrases or Regexp Matches. When you use this Outlook macro to complete the mail merge, you will be able to send from other email addresses, including a distribution group address in Exchange Global Address List or a shared mailbox. The contact card of the recipient will be the distribution lists contact card. Why to Export Office 365 Contacts to CSV or Excel ? Exporting contacts from MS Outlook or Outlook on the desktop is very easy but when it comes to export contacts from Office 365 to CSV, people found it’s quite a tough job. Create a html document with a table open tag using uipath (use activity write/append line to create a. ), you don't need to manually add each person's email address whenever you email these people. Production and Logistics Managers who want to create Excel reports from latest SAP data. Creating a Mail Merge Document in Microsoft Outlook 2016 for Windows Filed Under: Microsoft , Outlook 2016 , Windows July 11, 2018 The Mail Merge function provides the ability to create a personalized document that you will send to multiple recipients. When you create a distribution list, you can include addresses from several different sources. How to Get Data into an Excel Spreadsheet Very Quickly with PowerShell 4 Comments Posted by Tome on November 4, 2010 Make sure you also read part II of this article that shows another technique to satisfy the same requirement, i. I lost my Word / Excel / other file after opening it from email. Hi Melanie, You can use contact groups or distribution list in Microsoft Outlook to send an email to large groups with hundreds of members. Microsoft Outlook-How do you have emails by nickich | November 17, 2008 5:09 AM PST I'm looking for a way to set up one of my approval emails to send an attachment (which must be signed by. iYogi™ tech support can be accessed 24×7 at 1-877-524-9644 from the U. Distribution list is a grouping of email addresses collected under one name. Select Use an existing list and click Browse (fig 2). Adding a few hundred recipients to the "To:" field is a serious waste of time. csv) and take note of the name and location of the file as you save it so you can find it easily when you are importing it into GroupMail later. If you contained list of contacts in Microsoft Excel spreadsheet and want to access it through Microsoft Outlook or to other application that may access Address Book. Practice with sample questions is an effective way for students to study for upcoming exams. Outlook can import comma separated value (. Hey, Can send emails fine through VBA but can't work out how to send to an Outlook Distribution List e. Create a list of months. After selecting the (contiguous) data range, in the Pivot Table Wizard's Layout option, drag Treatment to the Row variable area, and X to the Data area. xlsx) spreadsheet file Contacts into Outlook (2016, 2013, 2010 ) Distribution List. If you want to keep the exported contacts separately in a group of collectively sending emails to this group of people then Excel to Outlook Converter software gives you an option to create & import excel contacts to outlook distribution list or groups and provides a name for it. Step 2: Type the names of your data labels in the first row (e. Get to know about easy steps to create a distribution list in Microsoft® Outlook 2010 on a Windows® 8 based PC by watching this video. First, note that there are important Excel options to check and potentially set if you are dealing with older (legacy) and non-default file types, such as those used in older versions of MS Excel. These 4 new task list templates demonstrate various techniques that you can use to spice up your lists in Excel. Excel Help and Outlook Distribution Lists Tutorial on how to split a column into two at a comma, space, or tab and also how to create a parent distribution list in Microsoft Outlook. The contact card of the recipient will be the distribution lists contact card. You can also click on an existing group to add more users to that distribution list. To grant a user Send As permissions; To send emails as a Distribution List. Create instant spreadsheets for your scratchwork. Open your Outlook, click Distribution List you try to export. Even restrict PDF edits. But, it'll only attach the Excel workbook to an Outlook task. One text attachment Sending Appointments or Meeting Requests directly from ABAP. Please try again later. Using the Code. This document explains the creation of a self-scoring, interactive quiz using Excel. (See examples below) 1. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file. Tell C# users how to: create a new Excel file and load Excel; merge, append, and split Excel files; insert, delete, move, rotate, copy and paste Excel file page. Then use an Import feature. How To: Create a Distribution List in Outlook December 7, 2009 Distribution lists are a great way to save time and energy when you want to send the same message to multiple recipients. MY GOAL: I will create a distribution list called External DL. Click the Review tab on the tool bar. As long as the addresses are one address per line or semi-colon delimited, you can use any list to create a contact group. Some options allow users to fax directly from the suite (for example, taking an open document in Microsoft Word and sending it as a fax) and others allow for sending a fax using a Microsoft Office document (for example, opening a program and selecting a Microsoft Word file). Additional information on this is available at multiple places SCN and SAP help. Select all the contacts in the list and add them to Members. Adding Document Properties in Excel. send the html file as body in the Outlook mail activity. Select 'Create PDF/XPS Document' and it will embed the spreadsheet into the PDF. How to create a list of contacts/emails to send group emails to in Office 365 Mail Online. However, you cannot use Excel histogram tools and need to reorder the categories and compute frequencies to build such charts. com wanted to send all of the files in a folder as email attachments, one attachment per message. MS Office 2010 Windows 7 I would like to know how I can take a distribution list in my Outlook Contacts and export them into an Excel document? Thank you for your help. To import Excel data into Outlook: Arrange the Excel data in the traditional database format; i. Right-Click the folder you want to create the file in, and then click properties on the shortcut menu to check your permissions for the folder. The Favorite Folders list appears in the top of the left panel in the open dialog box. The position listed below is not with Rapid Interviews but with Tapestry Our goal is to connect you with supportive resources in order to attain your dream career. One can even exclude duplicates upon export. 2 Methods to Export All Members of an Outlook Contact Group to Excel At times, you may want to export the members in a certain Outlook contact group. Moving Excel Tables Into Various Word Pages. Go ahead and click on it. Ok, guys, new to this forum and I need some help with a business invoice. You get a document from a colleague and you notice that each paragraph starts with a tab character. Some users are seeking a way to quickly create an Outlook contact group from an Excel file which contains a list of contacts. Use a distribution list in Outlook to send the same email to a group of recipients. Categories: Microsoft Outlook / No Responses / by OfficeTutes. Pick a fax number for a contact from your personal address book. Right-click the folder you want to create the file in, and then click Properties on the shortcut menu to check your permissions for the folder. The project page may also describe a bug-reporting procedure, or have a link to. Use this dialog box to assign the name Contacts to the entire range of contacts data. After you create your Excel data file, save it, and then close the data file. In future tutorials we will show you how to use your email templates in once click. Launch your Outlook application and shift to the Contacts view. This lets you send emails to the same groups of people easily, instead of adding them as individual recipients when composing messages. Allows the users to update SAP from within Excel, Outlook and Word. Then, select Trust Center. Once your Word doc with linked Excel sheet is ready, use the 'export' function under the File menu, rather than 'save as'. Creating Distribution List with VBA Excel Posted on August 20, 2012 by admin In the last post in Excel Category I talked about text functions and I posted a situation to create a distribution list from list of email ids in a column. Create a PDF from each sheet, attach that PDF to an Outlook email and then send it. Distributions of non-numeric data, e. Do you email the same people all the time? If yes, you need to create a Contact Group in Microsoft Outlook. How to create collapsible rows in Excel I was recently creating an Excel spreadsheet template for a friend and I needed to know how to create collapsible rows in Excel. An Excel mailing list can be shared with Outlook for contact management and email blasts, while the same list can merge with Word to create form letters or address and filing labels. I am trying to export global distribution list members (Not security groups) from an Active Directory/Exchange Group to an excel spreadsheet but it is not working I have a very basic knowledge on. Open the Excel workbook that you will create a contact group from, select the data, and press Ctrl + C keys together to copy it. Skip the endless chain of emails, meetings, chats and document versions by working simpler and faster with Quip on your Mac, iPad. Then you can create a contact group (formerly called a "distribution list") using the imported contact information. It's typically easier to create a distribution list when all the addresses already exist in an address book or Global Address List but doing so isn't necessary. frame then read this file in Excel. com How to create a contact group (distribution list) from Excel data? This method will guide you quickly create a contact group ( distribution list) from Excel data , without applying the Import and Export Wizard in Outlook. Click “Finish”. The email address of the site mailbox will be generated automatically from the name of the site. You don't need to sign up with Zoho. Do you email the same people all the time? If yes, you need to create a Contact Group in Microsoft Outlook. Creating Email Templates in Outlook 2016 In this tutorial we will discuss and show you how you can create custom pre-made templates in Outlook 2016 and how you can use them. This tutorial helps you learn how you can streamline your emails with Outlook’s built in distribution lists. Someone wanted to create SharePoint alerts on a document library, and they wanted it scheduled to run weekly on all new items. You may be using Microsoft Excel to organize a mailing list neatly. I have a couple different excel sheets with email addresses, for existing and potential clients. Navigate and open your spreadsheet. Microsoft Outlook distribution lists can save you time when you need to contact all of your employees at once or reach out to a specific group of customers. MS Office 2010 Windows 7 I would like to know how I can take a distribution list in my Outlook Contacts and export them into an Excel document? Thank you for your help. In this article, we are going to explain how to import Excel Contacts. Open Outlook and switch your attention to the right hand side of the Window. We have different people updating the file daily and it is really difficult to ensure they are using the correct distribution list. xlsx) spreadsheet file Contacts into Outlook (2016, 2013, 2010 ) Distribution List. German asked if there is a way to send one worksheet in a workbook as an e-mail attachment without sending the entire workbook. Click Spelling & Grammar on the Proofing group. I’ll begin with an existing Word form,. On the Contact Group ribbon, click Add Members. I have a couple different excel sheets with email addresses, for existing and potential clients. Finally, let’s add the contacts to a new group, and we can add it to the new folder. Is this possible?. Excel allows you to open HTML pages within the program, which is great for some purposes. Open Outlook and start a new email. Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. If you’re converting an Excel document, a second dialog box will appear with further options. For this example, make sure you have columns for “task” and “done” at the very least. The script below takes each user on each line and populates the Contacts for the "Shared List " Mailbox. The short answer is that you cannot—a worksheet, by itself, cannot exist as an "entity" that you can attach to an e-mail. Create columns in that list the correspond to what was in your Excel sheet. Distributions of non-numeric data, e. Using all possible combintations of file types from Excel, when I try to import I can get to the map custom fields (and BTW, I'm using filed names in Excel that match Outlook Calendar field names), the OK function is not activated. Step 1 : Just click the Mailings Menu and then click Start Mail Merge button. I have Windows XP and Microsoft Office 2007. I want to be able to click a link in Excel which will automatically open up a certain email within my Outlook so I don't have to fill up a box. Creating a distribution list from an excel document About this tutorial: Video duration: 1:2 Click ok do one or more of the following add an address from book a contacts folder. Open your Outlook, click Distribution List you try to export. Navigate and open your spreadsheet. Closed Word or Excel. Note: you cannot expand the Distribution List if it is hidden from the Address Book, or if it is a dynamic Distribution List. But as I use the script below I need update this Distribution List with an new contacts that I add to the excel spreadsheet. I have email address in column C in Excel, and would like to send the attached Excel document to those recipients in Column C. For more information about how to create a mail-merge address list, click the following article number to view the article in the Microsoft Knowledge Base:. I have email address in column C in Excel, and would like to send the attached Excel document to those recipients in Column C. Your Outlook mail, for instance, may consist of messages from a variety of contacts that cover multiple topics. But if you use Outlook to keep up with your obligations, a list in Excel isn't helpful. Get a complete list of all the distribution lists or distribution groups. The following is what I have been trying,. The first step is to go to the Excel Developer tab. Save your Excel spreadsheet as a comma separated value file (. On the Mailings tab, in the Start Mail Merge group, choose Select Recipients→Type a New List. Microsoft Excel 1. But sometimes the user wants to work with multiple users on the Excel file. Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Previously, i have manually amened the vba to contain the distribution list but this isnt really an option in this company as numerous people produce the reports with varying levels of ability and their are usually daily changes to th disto. Outlook Calendar Quick Reference 1 4/24/2013 Outlook Calendar Tips & Tricks The following provides information on using various features and functionality in Outlook calendar. All the software systems listed here include a free trial, so you can test the features and their relevance for your business before buying. How to create a list of contacts/emails to send group emails to in Office 365 Mail Online. I’ll begin with an existing Word form,. With WinCalendar you can easily print outlook calendar events with details and full word- wrap (prevents appointment text from being cut off), plus you can fully edit in Word or Excel before printing. To Solve these kind problems in MS Outlook. To create a distribution lists from excel spreadsheets you just need few simple steps to carry out, which is to convert excel to Outlook contacts form. First, note that there are important Excel options to check and potentially set if you are dealing with older (legacy) and non-default file types, such as those used in older versions of MS Excel. Managers who want to track projects and status automatically as they receive status e-mails. If you are creating a new group, Type the name of the group, then click OK. office Convert Excel to Image Jpg/Jpeg is the best choice for you to convert Excel to image. So this article will share you 2 means to extract the group members to Excel. Using the Code. What it does is make your Excel physically linked to SharePoint list. If you have a lot of business or personal contacts that you keep in an Excel spreadsheet, you can import them straight into Outlook. ), you don't need to manually add each person's email address whenever you email these people. This task is usually the most confusing, so follow the steps below carefully. In Excel, each address must occupy a separate cell. This link is a one way street where data updates made on SharePoint will be reflected in the Excel workbook, but any updates made within Excel will not get pushed through to the SharePoint list. How to quickly convert or copy email addresses column in Excel to Outlook email list? Supposing here is a column of email addresses, and what you need to do is copy these email to the To section of an Outlook email message as below screenshot shown. And on a Mac, you can save Word files as a rich PDF document in one click from the Acrobat ribbon. Launch Excel and open the spreadsheet with the email addresses to place into an Outlook distribution list. When you're done, you can email away about every little matter that is pertinent to this group. I am not sure how to do that and help would be appreciated. Note: If you use Outlook on the web, Office 365 Groups are available to you. Note: you cannot expand the Distribution List if it is hidden from the Address Book, or if it is a dynamic Distribution List. csv file format We can export Contacts from Outlook directly into. As such, learning how to create a document management system is critical for businesses. csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a. At times, you may want to create an Outlook task from an Excel file for follow up or other reasons. Include text in the email body and specify the recipient, CC and BCC. Here, under the find section you will see the address book. Transfer contacts list directly into Address Book of MS Outlook. The following is what I have been trying,. I've created a macro that works with outlook and excel that will use a list of email addresses (in excel) and send all those addresses an email (in outlook). Add Method is used to create new workbook. Here we are taking an example of prize distribution at a particular function where students of various schools have participated. One text attachment Sending Appointments or Meeting Requests directly from ABAP. Hi, I am trying to script out a macro that will take my list of contacts from Excel (2003) and paste them into a BCC field in Outlook 2010. Sending Email to a List of Recipients Using Excel and Outlook. Finally, display the spreadsheet by setting its visible attribute to “True. How to create a list of contacts/emails to send group emails to in Office 365 Mail Online. We work directly w. This article describes how to create such a distribution list. Free with a Google account. Finally, display the spreadsheet by setting its visible attribute to “True. Mail from Excel with Outlook (Windows) Outlook object model (attachment) Mail the whole workbook. Encryption is so important as decryption. One such tool is the Excel to Outlook Converter. With SharePoint Document Merge you can now automatically create documents from any list for any predefined document template directly from the Ribbon Menu (SharePoint Document Merge. To create a distribution lists from excel spreadsheets you just need few simple steps to carry out, which is to convert excel to Outlook contacts form. This problem occurs usually when Outlook cannot access the temp file the file is linked to. Mail more then one sheet. As a commercial real estate professional you spend a lot of time with clients. Now, I would like to change the vba code to send the email based on a distribution list from the excel file. In Outlook, create a new Contact Group or Distribution List (the name depends on your version of Outlook). While Office 365 distribution list comes with some extra features such as shared inbox/calendar, power shell management, Restore delete group etc. you can actually save the file as a text file from Word, then open that file in Excel Choose delimited - space - and it should make the columns for you. NET application will have the ability of processing images contained in Excel file. csv (Comma Separated Value). Convert a PDF document! Free up hundreds of hours of work with PDFTables. Shift to the People (or Contacts) view in Outlook, and click Home > New Contact Group to create a new contact group. How to use purchase order template. From the toolbar, select Insert > Hyperlink. First create a new Contact folder, by right clicking your Contacts folder, then New Folder. Linking Excel to Outlook e-mails. Alternatively you could use the import feature to add your contacts from Excel to a folder and then add the address to the distribution list. The short answer is that you cannot—a worksheet, by itself, cannot exist as an "entity" that you can attach to an e-mail. There are a variety of calendar templates available that you can customize to your liking, which will. This task is usually the most confusing, so follow the steps below carefully. When you create a distribution list, you can include addresses from several different sources. Pick a fax number for a contact from your personal address book. For now, only Outlook for Windows uses the simplified Ribbon in Office 365. In the Convert dialog box click ‘Change Icon’. That’s the Orientation menu. Create the distribution list. The following macro attaches one file to an email message and sends it, then sends the next file in the folder, repeating until all files are sent. This article describes how to create such a distribution list. When generating report, you can setup files or folder filters in order to display only the items you need, skipping the rest. Microsoft Outlook has the ability to create a distribution list from your Contacts list, and store that distribution list in the Contacts folder. From the newly-opened window, choose “Delimited”. Email distribution lists are invaluable when you correspond with groups of people on more than one occasion. Especially for staffs who work in office, Office file encryption seems more important than other files encryption and in common use too. You can cancel the export by not entering anything. First create a new Contact folder, by right clicking your Contacts folder, then New Folder. How to send mail to a distribution list or a group ID. Import Addresses from Excel® to Outlook® Address Book Step 1. Note: you cannot expand the Distribution List if it is hidden from the Address Book, or if it is a dynamic Distribution List. I have email address in column C in Excel, and would like to send the attached Excel document to those recipients in Column C. In future tutorials we will show you how to use your email templates in once click. Finally, display the spreadsheet by setting its visible attribute to “True. This would be incredibly time consuming. Save spreadsheets in OneDrive. ) The only requirement is that each member's information needs to be delimited with a semi-colon or paragraph mark (one name and address per line). Is this possible?. You must set up a calendar in Outlook first so you have a. In Excel, each address must occupy a separate cell. Make sure the ‘Import from another program or file’ section is selected and click next. For exporting distribution list (contact group) as csv file and import it to Excel from Outlook, please do as follows. Use a distribution list in Outlook to send the same email to a group of recipients. The completed routing slip will be attached to the final version of the routed document. Mail a row or rows to each person in a range. We also show how to send personalized mass emails using Outlook 2013 Set the Document Type to How do I attach an excel file to the email distribution list. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab. However, I would like to send the workbook to a distribution list in my outlook contacts called "Daily Matrix" and want to BCC them. In Excel, I had Microsoft Office 15. · A workflow which creates a new Word document and copies the fields from the list into the document. By Macro we mean a Sub. Open the address book list and select the contacts folder we created. The list will show one line of context for each match.