1. R

    Combobox - named ranges and criteria - VBA

    Hi, I have a macro button to open a userform mailing list (see image) which includes a combobox and listboxes. I had written code which got enhanced by member 'beyond Excel' below. Credits to him/her. The goal is to save the Sender, CC and Recipient addresses in named ranges on the data sheet...
  2. C

    Macro Help - web logs

    Complete Macro noob here... I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to...
  3. G

    Unstructured Addresses and Countries

    I have a column with full international addresses with no separators (commas or semicolons). I need to search each cell for a country name and put it in the cell next to it. I've tried to use the search function and it works with one country but when I introduce the full country list, I get a...
  4. H

    Open File If MAC Address Matches With That Mentioned In The Code

    Hello Friends, Is it possible to Open a file only for specific computers. A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are...
  5. R

    Need some guidance on how to approach this

    Hi Everyone, I need a little help with something. I have a report that I get twice a day, on emails that were sent to some of our generic inboxes. Each email has it's own row. Column C of this report contains a list of all the email addresses the email was sent to. There can be one or a...
  6. J

    Create email with same body but different addresses (using drop down menu)

    So I've got a drop down menu which creates an email. Body of the email is always the same but the addresses and subject change depending on the option chosen from the drop down list. It pulls the email addresses from a table and also inserts the contents of the clipboard to the body of the...
  7. R

    Separating multiple email addresses and names in Excel

    Hi, I need help with an Excel sheet. I have a list of users names and email addresses along with other data columns. Some of the Name and email cells contain multiple names and corresponing email address. I want to have these moved to their own row with all the other row/column data duplicated...
  8. A

    Can I use Mailto and body to generate an email that includes working hyperlinks

    Hello, I am new to excel and I am unsure if what I am trying to dois possible. I cannot use VBA/macros for this as our sharepoint site does notsupport macro enabled workbooks. I am using a mailto:formula to create an email, and I have body and subject set up...
  9. N


    Hi All, I have a one off task where I need to send multiple individual emails to various email addresses. I have all the addresses in row 2 and the text in cells in column L. This is what I am have come up with...
  10. M

    Emailing direct from Excel

    I have a workbook that has several sheets (one for each person) - is there a way that I could email the contents of each sheet directly from Excel to the 'body' of an email. If this is feasible - where would the email addresses need to be located ( a separate sheet or on each individual sheet...
  11. J

    Is there VBA to create multiple emails of specific cells based on email address in the same row?

    I have a worksheet with almost 1000 rows of data (userids) in column B and locations for that data in column C. In column A, I have email addresses for the owners of B. (there are 300 unique email addresses). I'm not super awesome at VBA, but assume that there is VBA to "extract" the unique...
  12. S

    Delete certain email addresses from a column?

    Hi. In column A i have thousands of rows of email addresses (1 address per row). What I want to do is run a macro which deletes all rows that aren't , so my list after running the macro only contains addresses with these domains. How do I achieve this?
  13. M

    Search for an IP address Using a Set of Ranges as Search Criteria

    I am trying to create a tool that will allow you to paste a column of IP addresses and have each address searched for in a range of IP addresses. For each address found in a range then Excel returns "yes", otherwise "no" The table below is a sample of the pasted addresses (column F) To the...
  14. C

    Filter Address missing #'s

    I'm trying to sort about 50-60k rows of data and doing so by manually going through the lists and deleting the rows that do not have the #### part of the address. Is there a way to filter down and see addresses that contain the Main St and not the 1234 Main St? like 123 Dunn Rd are ones I...
  15. A

    multi sheet reference for 1 cell/Impossible??

    I have an excel doc with several worksheets 1 summary sheet The rest are all different addresses, the address in each sheet is in cell B2 I would like a formula in the summary sheet the give the address in cell B2 and be able to drag the formula down to give the addresses for each different...
  16. K

    Open .msg file and add emails

    Hi, I have a macro for opening a .msg file but I need to also add email addresses. The email addresses will be different depending on the project. Is this possible? The macro I currently have is: Sub OpenOutlookMsg () Dim myoutapp As Object Dim myitem A Object Set myoutapp =...
  17. E

    VBA code to create move duplicate email adresses to new worksheet

    I have to run a report showing customer names, addresses and email addresses. Many times customers have the same email address as some other customer. I need to: Sort the first worksheet (call it "Email1") by email address; Add a formula in the column next to the email column: "=IF(O2=O3...
  18. F

    Expanding columns out into rows with unique criteria

    Hi All! First off, I apologize at my horrible attempt to title this thread - I'm sure there's a much better way to word it. I'm pretty stumped on this one. I'm working with a fairly large database (~5K rows) of reservation numbers & email addresses. Please forgive my poor attempt at describing...
  19. C

    Trying to find Data to Match

    Greetings Everyone! I've been learning a lot since I have been a part of this community and I want to say thank you! I have another question that I'm going to go in and try what I know and see how that goes, but if someone has a better suggestion, I'm all ears! We currently have three...
  20. S

    Excel Hyperlink question

    I wonder if someone could please help? I have a column of email addresses in plain text in excel 2016 that I need to convert to clickable email links? Is there a way that I can change all the email addresses to link at the same time? Any help would be appreciated. Kind regards, John.S Australia

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
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 "".
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