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.
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).
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
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 RelatedI have a list of names and email addresses in a single column.
It looks like this:
Jane Smith (jane.smith@gmail.com)
John Jones (john.jones@hotmail.com)
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?
I have a spreadsheet similar to the following.
Capture.PNG
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 "mailto:tom@hotmail.com" and if I ran the macro while in cell F7 it would produce the link "mailto:tom@hotmail.com;kate@hotmail.com".
I started tinkering with some code on my own but wasn't sure how to compile the results into a single link.
Is it possible to Launch individual Email addresses for names in a dropdown List?
View 14 Replies View RelatedI 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 RelatedI 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
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."
Code:
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] .......
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:
www.website.com/searchabc123etc=john+doe
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.
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 RelatedI'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.
Example:
Amyp@emailaddress.com
Treverp@emailaddress.com
I need to combine the names and separate by a semi colon: Amyp@emailaddress.com; Treverp@emailaddress.com
I started a concatenate formula, but because each name is on different row, it was a lot of manual formula tweaking.
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 :
=HYPERLINK("mailto:"&A2&"?subject="&B2,"Email")
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.
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 'middlesburg.john@gmail.com' that we get through an input box and in the list, we find John Middlesburg. Since it is obvious that John Middlesburg is middlesburg.john@gmail.com, how can I get it to go on through?
View 4 Replies View RelatedI 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.
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 ?
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??
Celebrant
Details
Abbey*Dayrell, Ms
12 Battunga Street, Wishart QLD 4122
Registered
p(H):*(07) 3349 3236*
[Code] ......
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:
name@email.com; name@email.com, etc.
[code]...
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 JB@excel.com (column G), for Task E (Row 9), an email will be sent to TB@excel.com,...etc.
I would prefer it if the info was sent as the actual message in the email instead of an excel attachment.
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.
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 "@example.com".
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
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 RelatedI 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?
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.
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.
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
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
Using excel 2007. I have a column with multiple items, a lot repeated.....how 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 RelatedI'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.
