Make 1 Unique Email List From 2 Other Email Lists (one List Minus Other)

Feb 26, 2013

Imagine this..

In Column A I have 500 email addresses.
In Column B I have 2000 email addresses.

Now in Column C, I want to have all the email addresses in Column B MINUS all the email addresses in Column A.

IE: So basically if Column B had 300 of the same email addresses in Column A, then Column C will have 1,700 email addresses (2,000 - 3000) = 1,7000.

View 1 Replies


Duplicates - Delete Every Lead On List A Whose Email Address Is Also In List B?

Jan 9, 2014

I am working on an email marketing project and i have a small problem. I have two different email list. One (List A) is a large list of potential leads. The other (List B) is a list of leads we are not supposed to market to. I need to delete every lead on List A whose email address is also in List B, so that we do not send unwanted emails to our clients.

The best way i have to do this so far is to go through line by line, which is very impractical.

In case it matters here is out list format. Each list has 10,000 + leads. Each lead occupies a row. The row stretches across 13 columns and each column holds a different variable about the lead (names, state, email address).

View 2 Replies View Related

Make Unique List From List Without Duplicates But Hold Cell And Pull Corresponding Dates

Apr 18, 2013

I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.

For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).

I am also going to upload a data sheet, and an expected results sheet.

unique list.xlsx

View 1 Replies View Related

Email List

Jun 19, 2009

I have an excel file I pulled from a database. Im going to use these emails for marketing. Is there so type of code or way that I can filter out the emails that are not complete or missing information? Im using excel 07

View 9 Replies View Related

Pull Just The Email Addresses From This List

Oct 27, 2008

I have a list of names and email addresses in a single column.

It looks like this:

Jane Smith (
John Jones (
list continues....

I need to pull just the email addresses from this list. Is there a function that will allow me to to do this?

View 5 Replies View Related

Email To List Based On Variable?

Jun 3, 2014

I have a spreadsheet similar to the following.


I am looking for macro that would do the following: I would run the macro while in a cell in row 7 (the row may vary if I insert more data). It will find all of the zeros in the column and make a single "mailto:" link that includes each corresponding email address in column B.

So if I ran the macro while in cell E7, it would produce a link in that cell such as "" and if I ran the macro while in cell F7 it would produce the link ";".

I started tinkering with some code on my own but wasn't sure how to compile the results into a single link.

View 4 Replies View Related

Launch Email With A Dropdown List

Oct 30, 2007

Is it possible to Launch individual Email addresses for names in a dropdown List?

View 14 Replies View Related

Sends An Email With A List Attached

Sep 25, 2008

I have a list of products in column A and a expiry column B. What I'm trying to do is when I open up excel, a macro gets invoked and creates a list of expiry products based on today, then sends me or someone else an email with a list attached or in body doesn't matter, so that I can attend to the problem. I've searched a lot of places and haven't found the right answer that I'm looking for. This shouldn't be new because I think others would have wanted to know something similar.

View 5 Replies View Related

Email To A List Of Names From Within Worksheet

Nov 9, 2008

I currently have a workbook that copies the first sheet and emails it to an individual on the first day of the week.

New requirements are for it to be sent to a list of people.

I am at an impasse on how to proceed due to lack of knowledge. The current code obtains the recipient from Sheet3 D4 and i would like to be able to list down this column for additional emails without restricting this to a set number of cells.

I have searched the forum and have been unable to find what i am after.

I have included a test file to show what i have so far.
We use Outlook 2k3
We use Excel 2k3

View 12 Replies View Related

VBA Concatenate Email List Range

May 25, 2012

I get the correct results in K1 when I have a list of email addresses in column D, but when it tries to email it states, "Unknown recipient name found in the list of recipient list. Use a valid name and try again."

Dim x As String, rng As Range, cel As Range
Dim myString As String
With ActiveSheet
Set rng = .Range("D2:D" & Range("A65536").End(xlUp).Row)

[Code] .......

View 2 Replies View Related

Get Email Addresses From List Of Names

Aug 22, 2007

I have a list of 200 first and last names...column A is first name, column B is last name.

I want to find their e-mail addresses easily...

My company has a website that is a searchable directory. Each person has a profile which contains the person's e-mail address in its own table.

The directory is set up such that when you search for a persons name, you get the following URL:

I am looking for an easy way to do 2 things:
1) combine the first and last name from separate columns into one single column such that it appears as john+doe (include the "+" sign)

2) take the "john+doe" cell value and paste it to the end of the URL

3) run a web query using the updated URL which imports 1 specific table from the person's profile, namely, their e-mail address.

I can successfully run a web query for 1 person manually. However, I am looking for a way to do this more efficiently for a list of 200 names.

View 9 Replies View Related

Create Unique List From 2 Lists

Oct 3, 2007

I have a number of text columns, side by side in a worksheet, containing names. I wish to combine these columns into one new column, removing any duplicates, to create a single list of names. Is there a simple way to do this?

View 3 Replies View Related

List Of Email Addresses That Need To Concatenate Into One Cell

Jan 17, 2013

I've got a list of over 170 names in excel rows that I need to quickly turn into a copy and paste list that I can mass email some of my sales people.


I need to combine the names and separate by a semi colon:;

I started a concatenate formula, but because each name is on different row, it was a lot of manual formula tweaking.

View 3 Replies View Related

Macros To Email Recipients List On Excel?

Apr 30, 2014

I have an excel sheet with 25,000+ emails in column A with hyperlinked emails addresses, Column B has different Subject lines based on the category the clients belongs to but on the same sheet, Column C has the following hyperlink :


To create a hyperlink of the email address with the desired subject line.

macros that i could use to open about 25/50 outlook message with the email ids in column A of the sheet and the subject lines in column B.

I don't want the messages to be sent automatically but i want to have the option to change the body of the email if necessary.

View 4 Replies View Related

Compare Email Address To List Of Names

Feb 21, 2014

I am trying to see if an email address matches with a list of names in a worksheet. If so, it would proceed with code. For example, I have an email address '' that we get through an input box and in the list, we find John Middlesburg. Since it is obvious that John Middlesburg is, how can I get it to go on through?

View 4 Replies View Related

Sending Email By Selecting From A List Of Addresses

Dec 2, 2008

I am attaching a workbook with the VBA code for sending email.

I found the code on this forum and changed a little bit to make it work for my application.
I am not sure if this is the most effective way, but it works.

The user would select from a list of names on sheet1 and click "send_mail" button. What I need done is to send sheet2 as an attachment.

The problem: The code is looking for address in cell "H7" on sheet2. I want to keep the address on sheet1, but send out sheet2.

If I copy the address from sheet1 to sheet2 in cell "H7", everything works fine. So I need soemone to help me change the code, so it will send out sheet2, but read address on sheet1.

View 9 Replies View Related

Excel 2010 :: Email Each Tab To Distribution List

Nov 10, 2011

I have a Macro in Excel 2010 which emails each tab to a distribution list.

However Outlook asks for permission each time to send the email, is there a way to disable this ?, or get Outlook to grant permission for a set amount of time ?

View 2 Replies View Related

Extract Email Addresses From Two Column List

Nov 18, 2012

I am trying to extract email addresses from a two column list. looks like the information may have been copied and pasted from a business card application of some sort. so first column contains name and a few other bits and pieces, the second column contains email address, phone numbers, status etc. unfortunately some records seem to be six lines, some seven.

I thought I might try using a pivot to create a list of the account names and then do a lookup/offset combination formula but i cannot seem to work into it the means to locate the "@" in the email address (to identify which line contains the email address). my end result will be two columns: name and email address. or maybe, since the name is already on the first line of each record, i could use some sort of formula to pull the email address up the first line of column c??


Abbey*Dayrell, Ms
12 Battunga Street, Wishart QLD 4122

p(H):*(07) 3349 3236*

[Code] ......

View 9 Replies View Related

Email Distribution List To Aggregate In A Cell

Jun 16, 2013

I have a list of employees and their e-mail addresses. There is also a column denoting whether they should be part of an email distribution list or not (if yes, denoted by an asterisk).

I need to aggregate all of the asterisked e-mail addresses in one cell. It also needs to be "active", i.e. having an IF statement for whether or not it has the asterisk and therefore should be included. Last requirement: the addresses need to be separated by a semi-column, then space (for easy copy and paste into Excel) like this:;, etc.

View 1 Replies View Related

Each Row In The List Has A Task And Assign Email Address

Jun 1, 2007


The above is basically an action list showing who needs to do what. Each row in the list has a task and an assignee and the assignee's email address

I want a macro (that will be attached to a button or text in column H) that will copy that entire row (as well as the headers in ROW 4) and email that info via the default email application being used on the users PC (most likely to be MS outlook). i.e if i click on the button or text in column H for Task A (Row 5), an email will be sent to (column G), for Task E (Row 9), an email will be sent to,...etc.

I would prefer it if the info was sent as the actual message in the email instead of an excel attachment.

View 9 Replies View Related

Email As Attachement One Spreadsheet From Range List

Feb 26, 2009

I am trying to send as an attachment "sheet1" to a email list in "sheet2" range "A1-A50"
I looked at Ron De Bruin examples but didn't find one to email a single sheet from a list.

I looked at examples at Mr. Excel but didn't find it. I apologize if I overlooked it. If I did just point me to it.

View 9 Replies View Related

Loop To Find Email Recipients From List With Duplicates

Aug 18, 2014

I'm trying to create a macro the saves a report and then opens an email dialogue box populating the recipients from a list. I have the following code so far but the receivers are constant.

[Code] .....

I have attached a simplified example of the list. The list is always sorted by time and date. Not including headers, the list can be from 1 to an unspecified number of users long and users may repeat throughout the list any number of times.

The user name always appears as their email address prefix and the email address will always end in "".

I am aware that a loop could perform this task but do not know how to employ it in this case as it must not repeat recipients and will also need to populate the EmTo line. Possibly a second loop for this?

Attached File : Report Test.xlsx

View 3 Replies View Related

Building A Unique Consol List From Multiple Other Lists

Feb 3, 2014

I am trying to automatically construct a unique consolidated lists from several other lists. I want this to be formulated in such a way that the mother list is uptodate and reflect all changes made to the subsidiary lists. I have attached an example of what I am trying to achieve.

View 8 Replies View Related

How To Email PowerPoint Attachment With List Of Emails In Excel File

Jan 24, 2014

I have got a list of email with identification number + email address. The PowerPoint are named by the identification number.

Can I send out the PowerPoint to the corresponding email address using VBA automatically? Or is there any other way to do it?

View 4 Replies View Related

Count Of List & Make Unique

Feb 8, 2008

I have created a VBA Script with the goal of taking an initial Excel Spreadsheet and essentially creating a summary of it. The original Spreadsheet has data in it such as:

110 Compact Car
110 Compact Car
111 Full Sized Car
111 Full Sized Car
111 Full Sized Car
113 Truck

The numerical part of the above data is in column A, and the description is in column B of the original spreadsheet. I have been successful in creating a new Spreadsheet, naming the columns with each unique entry from the first set of data, but I cannot seem to correctly formulate a looping statement which correctly counts the above. The solution that I would like to get to on the new sheet is the following:

110 Compact Car 2
111 Full Sized Car 3
113 Truck 1

The number after the descriptions would be generated by the VBA Script and placed into column C in the new Spreadsheet behind the correct description.

View 5 Replies View Related

Generate Outlook Email From Excel List Of Recipients Via Single Click?

Jan 2, 2014

I would like to generate a blank email with a list of recipients (no more than 40) in the 'To' field. I would like to do this in a single click on a cell with the text 'newsletter group' in it (cell B17). The recipients email addresses are in the format of one complete email address per cell in a column starting at C17 (C17, C18, C19, etc...). I thought I had found a way to do this (using the hyperlink function I think, but can't quite remember)but it turned out you could only string together about 8 email address before the function stopped working.

Also just to be clear, I don't want to send the workbook to the recipients.

View 4 Replies View Related

Formula To Generate Unique List Of Missing Values By Comparing Two Lists?

Mar 28, 2014

Is it possible to have a formula that generate a Unique list (List 1 and List 2) of Missing values in List 2 by comparing two lists? Something like this

List 1 List 2 Missing in List 2
1 1 3
3 4 6
5 5
6 6

View 3 Replies View Related

Make A List Of Unique Values Using 3 Different Columns?

Feb 26, 2014

See attached file with a smaller sample of the 1667 row table of data I am working with. What I am looking to do is make a list on another sheet of each every line with a county and have the corresponding Township and range with it. So if I have a cell and I select Audubon county, I would like a list to populate that has the 12 lines of Audubon county in column A, and the Township in column B and the Range in column C.

Excel Rate Example.xlsx

View 5 Replies View Related

Excel 2007 :: How To Make Unique List From Repeated Items

May 22, 2012

Using excel 2007. I have a column with multiple items, a lot do I make a to show just one of each item? I want a unique list of my column of repeated items.

View 3 Replies View Related

Matching Up Two Lists Of Email Addresses

Jan 29, 2013

I'm starting up my own business and need to add my e-shot signup list to my new CRM - my list has been fully cleaned and validated!

I have two lists of email addresses - one with 37,000 records on it (List A) and the other with 7,000 or so (List B).

Most of the email addresses in List B are also contained in List A (but not all). All of the records in List B also have contact numbers. All of the records in List A have a lot more segmentation information that is very useful to me.

I would like to cross-reference the two lists, so that the contact numbers from the duplicate records in List B are transferred to the corresponding records in List A, meaning that the records in List A keep the segmentation information but also have the contact numbers. I would then like the duplicate records from List B removed entirely.

I would also like the non-duplicate records in List B to be transferred to List A as brand new records.

I understand how to use conditional formatting to highlight duplicates but I just don't have the time to go through 7,000 highlighted records manually, copying the contact number over then removing the record. I also know how to remove duplicates using excel, but I really need the contact numbers to be transferred across before I do this.

View 3 Replies View Related

Copyrights 2005-15, All rights reserved