contact list

  1. M

    Extract name and company from email address

    I am working to organize a contact list, by using the email id as a reference point to extract the name (first & last) with the company name and set a unique serial number for each company name. I found some valuable formulas to achieve the attached design. However, it requires specifying a...
  2. W

    Simplifying a list of duplicate cells on another sheet

    Hey guys! So I have a large set of data that I've imported into Excel. It is a list of thousands of individuals, the companies they work for, and other information. What I'd like to do is create a list of each individual company and their respective info. But for example, at ABC Co. there are...
  3. Y

    Using VBA to send personalized emails

    Hi all, Im trying to send emails from an excel spreadsheet. I have names and email addresses in columns A & B. I also have an embedded text box with a generic message. My end goal would be to create send each person and email reading"Dear Name," followed by the text from the text box. I have...
  4. I

    Email a few lines of info to user defined list of addresses

    Hi, thanks for taking the time to read this problem. I'm trying to build a spreadsheet which will be used every time a new contract is booked centrally to email the offices who will receive it, and tell them what they need to know about it. I have one sheet which is just a big email list that...
  5. R

    Listing Tab Names

    Hi, I'm trying to make a contact list sheet for keeping track of which companies my coworkers have contacted for sponsorship. Each have their own tab to keep an updated list of who they've contacted, that makes it easy to see if anyone else has already contacted them. We would like it to have...
  6. S

    Formula to search for an ID in a column, based on a name in the same row.

    Hey, So I have a spreadsheet with two sheets, on the first is a list of contact details, including CRM ID numbers. First sheet: <tbody> CRM ID Full Name d2f6vr61-5v5r11vdv1-d6vd6g6e <tbody></tbody> Sonny Jim </tbody> On the second sheet I have details of opportunities, the only...
  7. T

    Macro for contact list management?

    I have a worksheet with 1000+ unique company names listed in column A. A string of company executive names are then listed in column B (separated by semicolons) which corresponds directly to the company listed in column A. Similiarly, Column C (also separated by semicolons) contains executive...
  8. M

    Transposing a list

    I have a list I would like to transpose. Below is an example. <table x:str="" style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top