Macro to send multiple emails with different attachments. I want to read more than one cell for finding attachments.

It's pretty flexible about sending data and reports. Currently it's only attaching first file path only. My goal is to send multiple emails to different people (ex: A1 = email person 1) with . CreateItem(olMailItem) For i = 2 To 5 mailto = mailto & Cells(i, 2) & ";" Next i For j = 2 To 5 source = "F:\SOFTEKO\61-0055\New folder\" & Cells(j Feb 26, 2018 · I am currently trying to write a macro where it will email multiple attachments to recipients depending on whether each column has an X next to their name. htmlIn a previous video, we saw Sep 11, 2021 · Welcome to the Forum TUNIN96! Please attach a file showing the List of email addresses to send to (see yellow banner at the top of the page), any existing VBA you have, a description of the documents you want to attach, and the name of the email client you are using (easier if you are using Outlook). Aug 25, 2021 · Help to modify the following code to be able to attach two file paths as attachments to send mail using MailCDO object in MS Access. My file is set up so that Jun 1, 2016 · So employees will have a list of clients they need to send an email to, and each client will have specific information like name, client number, etc. Thanks, I'm a bit unsure, as I'm not really an expert at this. How to send Emails Using Excel Macros2. If column C has the same value the attachments in column G will be sent together to the same email recipiente (column F). Make a list in Sheets("Sheet1") with : In column A : Names of the people In column B : E-mail addresses In column C:Z : Filenames like this C:\Data\Book2. CreateItem(0) Application. comCode available her . ; Sub massEmails() Dim appOutlook As Object Dim Email As Object Dim mailbody, mailto As String Dim i, j As Integer Set appOutlook = CreateObject("Outlook. It has many useful features. Now, if you want to add attachments with all the emails that you wish to send. I am looking to add code to: Pull in the date from column D to the body of the email. In column A : Names of the people In column B : E-mail addresses In column C:Z : Filenames like this C:\Data\Book2. Application Set emailExcel = New Outlook. , and the employees should be able to click the "Send Email" macro button that's built in, and different emails will populate in Outlook with the specific info for each client built into the Email Sep 23, 2015 · Query--I need to send multiple emails to different recipients with different attachments. Note that Gmail no longer permits third-party app access, meaning you'll first have to enable Gmail's 2-step authentication . How to send bulk emails from Outlook Using Excel VBA? To send bulk emails from Outlook using VBA Send email from Excel, follow these steps: 1) First, prepare an Excel spreadsheet with recipient email addresses, subject, and body. Pretty much what I'm trying to do is send about 70 emails to 70 different email addresses with different attachments for each of them. I personalize the contents using HTML in Excel. 1 and attach. I have MANY emails from the same person but with different dates and different attachments and right now I am doing them one by one. This is an overview: Sub Send_Email_with_Attachment() Dim MyOutlook As Object Set MyOutlook = CreateObject("Outlook. I started with Ron de Bruin's code to attach multiple files to an email and then found more code that will loop through a folder to attach multiple files to an email. Add rngAttachment3. Send . WorksheetFunction. Jul 1, 2020 · Please do as follows to send an email with multiple attachments attached in Excel. Features like adding attachments, having a custom subject, using the CC and BCC fields, using "Send As" (e. MailItem Set emailItemObj = emailExcel. I have a list of 200+ emails which I would need to send individual emails to as they require different attachment for them. Display, you can use . The last section of code shows how to loop over data and send multiple emails with one attachment each. For now, 2 but might be more in the future. I tried using comma, using & sign and nothing seems to work. Most of the code is from searching, but it is not working as expected. I want 2 objects contacts and account object and send an email in 2 different objects in Feb 9, 2024 · FREE Download : Send Multiple Email Tool - Ver 3. Define the properties carefully. I want to read more than one cell for finding attachments. To = "[email protected]" emailItemObj. Crystal Laird September 25, 2014 at 11:27 am. 6 days ago · 7. For example, I have a range in A1:F30, with an email address in H1, with a different range in A32:F62, with a different email address in H32, and so on. Here is my issue: When I use the mail merge toolkit and Word and Outlook to send messages, it will load the messages into my outbox on Outlook but they will send very slowly (like one message very minute or every 2 minutes) so sending 500 messages takes overnight. Here in this article, I am going to show you how to send emails from Excel dynamically using VBA and Outlook. Aug 24, 2023 · To have it done, click the Preview Results button on the Mailings tab, and then use the arrow buttons to view all the emails. Jun 25, 2020 · I really need to know if there is ANY way other than a VBA code to bulk save multiple attachments from different emails in Microsoft Exchange. Excel macro/VBA code available in this post: https://excelmacroclass. 0 - Let's excel in Excel - […] of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email… VBA code for sending email from Gmail or yahoo - LearnExcelMacro. Criteria: Column C; Path to pdf file: Column G; Email recipiente: Column F. 30 Distinct Files 2. Jan 18, 2023 · Excel VBA Macro: Send Multiple Emails (with Multiple Attachments)Code (YouTube doesn't allow brackets; so LT and GT are used for less than and greater than, Learn to send multiple Outlook emails using Excel VBA. I want to go to a specific folder, attach all PDF files in the folder then go to a different folder Jun 27, 2020 · I want to adapt the following VBA code to send emails with multiple attachments (pdf) to recipients depending on a value existing in column C. com" 'optional. Although useful, it lacked one important ability: attaching user-specific files (i. Here's the code without the attachments. Email "[email protected];[email protected]", Subject:=:Example Email", Body:="Example Mail" You can search your sheet containing emails for the set of emails you need to send mail to, add each email to a string with a semicolon between each one. Step 1 – Open the VBA editor; Step 2 – Create a new module; Extra step for MacOs; Step 3 – Run the code; Step 4 – Automate the sending process; How to send bulk emails with different attachments from Outlook. I have put in the code for the body of the email where I want the date to go. Aug 8, 2018 · Make powerful macros with our free VBA Developer Kit. Nov 30, 2019 · How to send emails to multiple persons with multiple attachments automatically with VBA. I have the email addresses in column G and 11 different report names ranging from columns H:R. com" 'Mandatory. Body = Range("B2"). To send an email, you need to declare another variable that will use MS Outlook's property to refer to a new email. BCC property (instead of . I can do this by hand but it takes forever to change the filter, copy/paste, or export the report and then create and send the email, even just for a few people. The recipient email addresses must be in column A, and the body text of the email must be in the first text box on the active sheet. In VBA, to send emails from Excel, we can automatically automate our mailing feature to send emails to multiple users at a time. Application") Set Email = appOutlook. CreateItem(olMailItem) MyMail. Now, I need to send email with multiple attachments. Range Jul 6, 2020 · Rather than use Word, I used Excel and laid one worksheet out with the boilerplate email text, and on another sheet had one row per recipient with the "merge" fields (name, email address etc) and the name of each file in different columns. Value. send as the CEO - you know you want to), and best of all you can save to drafts to check the emails before they go out. For one, I hate not being able to name the attached file. Apr 6, 2015 · I send about thirty emails which has distinct attachments to the same emails. It requires considerable knowledge of VBA and its methods to write the code to send emails from excel. Application") Dim i As Integer Dim last_row As Integer last_row = Application. Any tips would be greatly appreciated. With the help of VBA, we Mar 16, 2023 · Review the email and attachment, then click ‘Send’. CC) like this,. Display 'Instead of . To do this you will need to use the VBA code shown below or included in this download. Row Set Mail_Object = CreateObject("Outlook. If you need a record of the files sent, press Ctrl+G to open the Immediate window in the VBA Editor to view the list created by Debug. But sometimes, going old school is all we need. I don't have a button to run the macro, as soon as the value went under the target value, it automatically sent the email. Add rngAttachment2. 8. CC = "[email protected]" MyMail. I don't want to download any 3rd party toolkits, just trying to figure out if it can be done with MS Word Mail Merge. Enter the following code into the module: Sub attachments() Dim appOutlook As Object Dim Email As Object Dim source, mailto As String Dim i, j As Integer Set appOutlook = CreateObject("Outlook. MailItem Dim inputDate As String, subjectFilter As Sep 23, 2020 · Can I send a mail merge with several attachments? This is specifically attaching several PDF documents to the email and send out. I am right clicking each file and using "Send To". The target value for each worksheet is a different figure, also, the attachment that needs to be sent is different. Enter this code send the email using the Send method. And when I do this regularly it's even more tedious and time consuming. Sample code provided by: Holy Macro! Books, Holy Macro! It's 2,500 Excel VBA Examples Sep 10, 2009 · I tried recording a macro in Excel to create an e-mail attachment of each salesperson's workbook and send it, but it did not record the Outlook piece. The advantage of Gmail over Outlook is you can use an Add-on that is free to send different attachments to differe Nov 15, 2016 · I am new to VBA and have pieced together a code to send multiple emails. 2) Enable the “Microsoft Outlook Object Library” reference in VBA. VBA novice and seeking some expertise assistance. com - […] DOWNLOAD : EXCEL MACRO APPLICATION TO SEND MULTIPLE EMAILS – 2. Activate With ActiveSheet Set rngTo = . For i = 2 To n Set msg = outlook. ; Click Insert and select Module. I figured VBA would be the best way but I'm stuck as I mentioned before. In the VB Editor, go to Tools, then References: Sep 16, 2018 · Use: Set OutMail = OutApp. Print fName. Cells (2,8). blogspot. Eg 1: Send one email with multiple attachments. End(xlUp). To = strEmailTo . Person1 receives BOTH attch. Every email is different and is going to different people. I am not looking to Merge TO Adobe PDF. A = Send To B = CC C = Message D-R = File names including the path The code creates Feb 7, 2014 · Hello VBA and Excel Experts! I have two pieces of code that each work, but I am struggling to combine the two. Is there a way to write a macro that performs this task? The problem with the set of code below is two-fold: 1) I have 3 COLUMNS of data in an Excel file: One for subject, one for email address to send to, and the third for the FILE PATH of where the attachment to be attached is stored. Send email from Excel with a PDF attachment. Put email addresses in a list, choose a folder to store the PDF files, then click a button to send the emails, or do a test first. Oct 13, 2015 · I am trying to automate sending emails with multiple lines and paragraphs through excel using VBA. 3 and attch. I have MS 365. I was able to change a macro find on the internet (see below) I'd like to send multiple attachments. The cells contain the messages. However, keep in mind that VBA macros require a certain level of technical knowledge and must be used with caution to avoid potential security risks. This will be the template that you will use to send multiple emails with different attachments. xls (don't have to be Excel files) Apr 30, 2024 · Step 11: Send the Email . Jun 22, 2022 · I am using VBA code to send emails from an Excel sheet: I use code to generate a separate email for each email address in Column C with a file attached. Here's the complete VBA code:Option ExplicitSub sendEmailsToMultipleP Sep 29, 2023 · Using VBA macros provides flexibility and automation in downloading attachments from multiple emails in Outlook. Nov 2, 2020 · Hi, I'm not really good at VBA. Value MyMail. g. Step 6. Jul 19, 2023 · Home > Macros > Basics > Email. ; Copy the following code and paste it into the Module window. To send an email via Outlook and to access the various features of Outlook, we need to create a reference to the Outlook Object library. Range("A:A")) For i = 2 To last_row Set msg = oa. The full code is; If you want to send the emails using BCC, simply use the . Add all the “To Addresses” under the column A heading. BCC = sMail_id. On the Mailings tab, in the Finish group, click Finish & Merge, and then select Send E-mail Messages…. com" strSubject = "Please find finance file attached" strBody = "some text goes here for the body of the email" 'call the function to send the email If SendActiveWorkbook(strTo, strSubject, , strBody) = true then Msgbox Mar 20, 2015 · I'm using the code below, in outlook vba, to create an email, attach a file, and send the email. We want to update this template using VBA code to create a static version and email it to a list of people. Application") Set objMail = objOutlook. Jan 25, 2024 · How to send bulk emails from Outlook using Excel and VBA. Here is the code I have so far: Sub Send_Email() Dim Email_Subject, Email_Send_From, Email_Send_T Jun 21, 2017 · If you have a file to send, right click on it and select 'send to' and then 'email as a step in the project'. Now the mailing feature is offered by Microsoft in Outlook, we will use the methods and properties of outlook Jun 23, 2020 · Each file goes to a different email address. Jun 19, 2022 · I am using the following code to send emails. CreateItem(olMailItem) emailItemObj. MAPIFolder Dim outAttachment As Outlook. In our scenario we have a table containing training delegate details. " Dec 2, 2016 · I'm trying to write a script which send multiple emails to addressees on a spreadsheet, with various other pieces of information. Sending Mail using outMail object: Below lines will define the target mail id, cc, bcc, subject, body, attachment and send command. Aug 23, 2023 · Enter the recipient's email address and compose the subject and body of the email as desired. {Added}. To = Range("A" & i). Will be sent to the same emails. Sep 16, 2021 · Hi, I am looking to create a flow that sends an email to multiple addresses (around 50), with each email having a different attachment, as well as variables within the body of the email, such as a 'Dear *First Name*,' input. Dec 2, 2016 · I have a macro in excel that looks down a column of email address and sends an individual email to those addresses with a specified attachment. smith@gmail. To = "abcd. Body = strbody '. I currently have a database program that I run to extract files I have set up that include excel, word, and pdf files. Before sending multiple emails, you need to gather and organize the attachments you want to include in each email. Set EmailApp = New Outlook. In this part 3 of our series, we cover two examples. nl insted the emails in column "G" Also I still don't know how to add the path to attachments =( Sorry my VBA knowledge is very limited, I have something similar set up already and it uses & ws. This type of automation means accessing a feature of another application using any other application. Oct 15, 2021 · Hi, I am trying to create a VBA macro that will generate outlook emails based on unique information in the cells. This tutorial covers everything you need to know to be able to write simple working macros to send emails from within Microsoft Excel and also a simple non-macro method. My code is below: Sub Send_email_fromexcel() Dim edress As String Dim CC As String Dim Mar 11, 2020 · Here's the scenario: I want to send different pages of my pivot table report to different email recipients. 5 etc). Remember, the properties are case sensitive. Scenario: We have an excel based reporting template. Summary 1. However, I am struggling with how I can add additional attachments (some of them are excel files and some are PDF files) to each of the emails. , attachments) to each outgoing email message. Value & _ to pull the body, subject & email address from excel cells. The Excel macro then takes this block and then puts them through a do-while loop and sends the emails one Jan 18, 2016 · You can use Gmail to perform a mail merge. In this video I demonstrate how to automate sending emails (including attachment) from Excel. May 30, 2022 · #BulkEmail #VBAAutomationHello Friends, In this video, you will learn how to create an Automated Bulk Emailer with Multiple Attachments and the "From" option Mar 1, 2023 · We can send emails through VBA. Jul 9, 2018 · Try this solution from Ron deBruin. Aug 11, 2021 · Sub Send_Multiple_Email() Dim sh As Worksheet Set sh = ThisWorkbook. Here you define the destination mail id. Just a couple more clicks, and your mailings will be on their way. Namespace Dim outFolder As Outlook. This is the final code: Sub SendEmailFromExcelWithBody() Dim emailExcel As Outlook. Jul 5, 2024 · The VBA window will open. It works fine, except I can't figure out how to add multiple attachments to a single email? Any help is greatly appreciated. display 'disable display and enable send to send automatically End With Next i Feb 13, 2018 · To use this macro, open the VBA editor, add a new module and paste the code into it. Subject = "Sending Email with VBA. Add . Mar 13, 2016 · Outlook VBA to save attachment from a mail,and then copy the attachment data in another excel and send the send excel via mail 3 Sending multiple attachments from excel sheet with VBA I tried to find what I could online using Google or looking at past posts but I'm stuck at only being able to send one email. Add rngAttachment. How to Email multiple tables in Excel as HTML table in Body using VBA? Although you can send and receive emails from Outlook directly, you can actually automate the process using a simple macro. xlsx files to be sent) Sep 12, 2021 · The following code example shows how to send an email to a list of recipients based on data stored in a workbook. CreateItem(0) 'The block that creates the email: With OutMail . Sheets("Sheet3") Dim oa As Object Dim msg As Object Set oa = CreateObject("outlook. emailItemObj. When I distribute those to my list of email recipients, each person receives variations of each report; for example the detail IS each department manager receives only the page # that applies for their department instead of the Aug 10, 2022 · Sub SendMail() Dim strTo As String Dim strSubject As String Dim strBody As String 'populate variables strTo = "jon. Count, "A"). com/2023/05/send-multiple-emails-from-excel-vba. 1. So far, using excel inputs to add variables to the email, including a li Hi, I've tested this and all the emails are sent to ron@debruin. Thanks for Public Sub Extract_Outlook_Email_Attachments() Dim OutlookOpened As Boolean Dim outApp As Outlook. Send. . Change fldName to use the correct path then run the macro. To: Reference to cell "A1" Sep 8, 2015 · This, very simply, allows the user to send emails to multiple recipients with different attachments for each. BCC = "[email protected]" MyMail. 3. Automating Email Dispatch with Mail Merge. Click on one attachment, then Save All Attachments to download everything in a click. My code: Sub Using the mail merge in word will send an email for each line of excel data (same person ends up receiving one email for each line item), but if I want to send only one email with multiple line items in it. createitem(0) msg. The macro works perfectly, however I am unsure how to adapt the macro to be able to send two attachments in the same email. You need to do some setup in tools--> options and the mail is sent from your pc, not from the server. xls (don't have to be Excel files) The Macro will loop through each row in "Sheet1" and if there is a E-mail address in column B and file name(s) in column C:Z it will create a mail with this information and send it. Application Dim emailItemObj As Outlook. Application. Value '. To help you make macros like this, we built a free VBA Developer Kit and wrote the Big Book of Excel VBA Macros full of hundreds of pre-built macros to help you master file I/O, arrays, strings and more - grab your free copy below. 2; Person2 receives attch. I can't tell you how many times I've attached a file named "Book1. e. Application") For i = 2 To lr With Mail_Object. In my spreadsheet I put the emails and file paths in cells, and the For loop picks out each individual recipient and file each time it runs through. Attachment Dim outItem As Object Dim saveFolder As String Dim outMailItem As Outlook. Here is what I have: Column A - To Email. Since posting my original request I've found some code that calls the Outlook application directly in Excel, completes the e-mail fields with variable results, and attaches a workbook, which may Apr 21, 2017 · My thought was that I would assign each e-mail a unique ID in column 2 and that it would skip generating the e-mail if the row had the same unique ID as the row before it, but it would include the numbers from column 4 and the attachments based on the file path in columns six and seven for all subsequent rows that were equal to that unique ID. CC = strCCTo . I need some VBA to allow me to send multiple emails (same standard email body but each with their own individual Excel attachment). To manually save multiple attachments, you can: Open each email and save attachments individually. to = sh. SentOnBehalfOfName = sheet. We start off with typing the file paths directly into the code and then Jun 18, 2013 · Multiple emails can be sent by separating addresses with a semicolon. Send to send the email _ End With Set objOutlook = Nothing Set objMail = Nothing Set rngTo = Nothing Set rngCc = Nothing Set rngSub = Nothing Set rngMessage = Nothing Set rngAttachment Thank you for writing this very useful program for sending many emails with attachments. Jun 20, 2024 · Develop a Macro to send an email to an address in a cell. Application") Dim MyMail As Object Set MyMail = MyOutlook. Apr 23, 2012 · Ever wondered how we can use Excel to send emails thru Outlook? We can use Excel VBA Macros to send emails to others thru Outlook. 0 […] Mar 25, 2015 · Sub CreateMail() Dim objOutlook As Object Dim objMail As Object Dim rngTo As Range Dim rngSubject As Range Dim rngBody As Range Dim rngAttach As Range Set objOutlook = CreateObject("Outlook. Value . something like this: Here is my code: Oct 27, 2016 · I'm by no means an expert and I want to send the multiple and different attachments (e. Jan 26, 2024 · Learn how to send emails from Microsoft Excel with and without VBA macros, to multiple recipients, with attachments, in plain text or HTML format, and more! Skip to Navigation Main navigation Jun 19, 2019 · I found a code online that sends emails to multiple recipients that attaches one file per email. You can add thousands of emails if you want. Please insert a command button by clicking Developer > Insert > Command Button (ActiveX Control) . Dec 12, 2017 · This is the first time I'm posting on this forum and I'm a Macro dummy right now so I need some help. My project is send email with the proper attachment (stored in the specific folder). mail. However, to do so, we need to remember that we may do it by outlook, another product of outlook, so we need to enable outlook scripting in VBA. Subject = Range("B1"). Send out personalized bulk email. I'm using Microsoft Outlook and Excel 365 Workbook Entitled: 'Raw Data' Sheet Entitled 'Sheet1' Column A: Email Address Column B: First Name (for email greeting) Column C: Attachment Path (. Step 2: Prepare Attachments. I have data in excel like column A have approx. Display End With 'destroy the object when you are done with that particular email Set OutMail = Nothing Next email Set OutApp = Nothing Jun 12, 2024 · VBA Code to Send Emails From Excel. Step 1 – Get your spreadsheet ready; Step 2 – Launch the Secure Jul 18, 2024 · Let’s not beat around the bush—saving attachments manually from each email can be like watching paint dry. xlsx" to someone. Send Reminder Email Automatically from an Excel Worksheet Using VBA; Send Email from Excel VBA without Outlook: 4 Suitable Examples; Macro to Send Email from Excel (5 Suitable Examples) How to Send an Email to an Address in a Cell using an Excel Macro- 2 Methods Sep 18, 2022 · VBA to Send Email from Excel with a File as Attachment and image in Mail BodyIn this tutorial, we will learn to automate the email. You'll learn how to automate: adding multiple recipients; sending attachments; sending the current workbook; changing the email body and subject; adding CC (Carbon Copy) recipients Sep 20, 2013 · Hello, I am looking for a VBA that can automatically send emails to many different recipients, each with a different attachment based on the range associated with the email address. CC = "[email Mar 8, 2023 · Column B = Name of Persons corresponding to email addresses. Column B - CC Emails. With outMail . When the task of sending multiple emails with different attachments becomes too cumbersome to handle manually, automation is the key. Jan 20, 2021 · Use Word mail merge to send emails, with all the missing features added back in. I have a macro that exports the files to my harddrive then invokes a module with this VB code. tech-sdhn. Repeat the process for each unique recipient and attachment. Is there a queuing function in MS Outlook? Or, is there a VBA code I can use to achieve the same thing. May 12, 2010 · Sub SendEm() Dim i As Integer, Mail_Object, Email_Subject, o As Variant, lr As Long lr = Cells(Rows. 50 email ids, column B have subject of email and column c have path of PDF attachments. Attachments. How to Attach files in an Email using Excel Macros Aug 9, 2019 · Try it this way. CountA(sh. I've started to use a solution from Ron de Bruin (below). Once you've added one file, you can add others. Jul 8, 2021 · In this video, we create a macro that automatically sends an email with multiple attachments in Outlook. Sep 4, 2015 · How to write an apex class for contacts and account object and send an email as an attachment by single mail. In this tutorial we would learn:1. Jun 15, 2020 · Sending multiple emails with different attachments is an AMAZING feature! Thank you Microsoft! :)Download file from here: www. Please help. Range("A" & i May 2, 2024 · Posts from: Excel VBA Send Email. ScreenUpdating = False Worksheets("Mail List"). Now I'm stucking in the final step. The table includes name, email address, course title and course certificate… Read More »VBA to Automate Sending Email From Excel Table with Jun 3, 2024 · Type in column headings in row A1: Email To (A); Email CC (B); Email Subject (C); Email Body (D), Attachment (E), Status (F). Jul 24, 2021 · From last week till now, I have a several question here to did the mini project send email with attachment by Excel VBA. I need to type the email dresses each time. Jul 3, 2019 · I have a working macro to send communications to hundreds of employees. I have explained the attachment and other properties here. Jun 25, 2024 · Add the VBA Code. May 27, 2015 · This annoyance inspired me to create a couple of VBA macros allowing me to add a little more functionality to Microsoft's Email As Attachment idea. Subject = strToday & " - Agreement" . Apr 29, 2021 · In a previous post, Mail Merge from Excel, we demonstrated how to create individual email messages using data from Excel and a template from Word. Apr 25, 2023 · To send email from Microsoft Excel, we'll be using Gmail, though you can customize the macro below to work with other email clients. CreateItem(o) . Oct 6, 2010 · Actually, I found some VB code that will work, and it is awesome!!!! It is a workaround, but doable. Eg 2: Send multiple emails with multiple attachments. I need it to be able to generate numerous emails at a time without having to rerun the script. . It’s easy to copy and paste a macro like this, but it’s harder make one on your own. BCC = "" . Next, create an instance of a new object separately. Blank Email Template. Application Dim outNs As Outlook. I have a list of multiple users, and each have varying file attachments. cc = "cc. Send Email from Excel with PDF. TextBody referencing the cell has the name (ex: B1 = name of person 1) Example of the two variables and how it would look like in an email:. We will define the recipient list in a separate sheet. To = Range("B3"). CreateItem(olMailItem) For i = 2 To 5 mailto = mailto & Cells(i, 2) & ";" Next i Greetings all. de us af me xd tk gd yt el ru