email address

  1. R

    Assigning a variable to a databodyrange?

    I'm using PowerQuery to produce a table containing one column of email addresses. I want these email addresses to be my distribution list in an email. I'm using VBA to create an email window with the addresses already populated. Originally, I was using a loop to cycle through the column of...
  2. B

    E-Mail address validation (Multiple contacts per cell)

    I am looking for a solution , but starting cell B2 I have a group of contacts to be e-mailed that needs to be checked for proper format. COLUMN A COLUMN B AREA (A1) E-MAILS (B1) Inspection 'test@abc.com; ab@abc.com; abc@abc.com; Machining 'abcd@abc.com; abcde@abc.com; Thanks for any...
  3. B

    form filler that seraches a separate workbook for data and emails answer

    Hi, I require assistance with the following On Sheet 1, the person completes a form (each cell contains a drop down menu) - once the form is completed they press "SUBMIT" a search is done on a separate workbook based on the info provided on the form - answers are emailed to the requestor...
  4. A

    Extracting email addresses from multiple columns

    Hi, Does anyone know of a simple way of extracting only email addresses from multiple rows and columns from a very large/disorganised spreadsheet? Many thanks, Adam
  5. S

    Email Address Validation

    Hi, I came across this formula that validates an email address: =AND(FIND("@",A1),FIND(".",A1),ISERROR(FIND(" ",A1))) It works fine if the "@" or/and dot is missing but it doesn't check for these rules: - the "@" comes 1st then the dot, - the "@" and the "." are separated (don't come together)...
  6. L

    How to copy the senders address in Outlook

    I would like to have a script that takes the email address ex. "Fake_Name@example.com" & sets the attachment to "Fake_Name" then saves that file to a set folder. I am struggling with capturing the email address. Is this possible? Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt...
  7. G

    VBA: Extract matching first name from email address

    Hi All, I have a long list of email addresses, all in random formats (ie. not your standard first.last@domain.com). I also have a long list of 5k first names. The macro needs to search each email address for a matching first name from 5k list and return the name when a match occurs. The logic...
  8. R

    DIFFICULT: Merging sets of data into one master column by using email as identifier?

    Hey guys, First off I'll start by saying I'm decent at best with excel.. So don't expect me to know a whole lot, so don't be afraid to get "laymans terms" with me.. I know what I'm good at, and excel is NOT it. That being said: I have a master list of email addresses with corresponding...
  9. P

    Easy Excel Question

    Hey guys, I have a list of email addresses in column A and i have a unique identifier in column B that corresponds to the email address in column A, in a perfect world there would be one email address that corresponds to one unique identifier. I need to know when i have an email address that...
  10. S

    Sending Individul Emails to list of people.

    Hi there! I'm a beginner when it comes to excel but I found found these forums useful to do a few basic things when it comes to using it. After a while searching I could not find anything which I can do myself. I am look for a way to send out an individual email to a list (Column A) in my...
  11. A

    Userform textbox email address not 'live' link after transfer to worksheet

    Hi All I have a userform where users enter name, email and telephone details then click a commandbutton to transfer values to a worksheet after finding the first blank row in a range. Here is the code: Dim wsEnrol as Worksheet Dim irow as Long Set wsEnrol = Sheets("Enrol Schedule")irow =...
  12. D

    Do the 4,000+ Emails I was Given Exist? Help Appreciated

    Hi All, So, I have a list of 4,000+ emails in excel (just finished scrubbing them) and I need to verify that the emails are existent. As in, Joeblow@gmail.com is an actual email address. Scoured the net for a ways to do this, in an automated fashion ofcourse, but have yet to come across a...
  13. H

    Compile Error : Expected Array

    Hey, I am trying to select all of the e-mail addresses in a table and display them without duplicates. The table name is "Signed Leases", the column name is "Email" and i am trying to place it in "text4". I receive an error message "Compile Error : Expected Array" at the "emails(count) =" line...
  14. G

    Retrieve the Users Email address

    Hi - I've got a work file that is on our company's network. I'm trying to put in a layer of security to ensure that when someone opens up the file, a macro will run and check the Users email address (in our Outlook) to make sure the email address has our company's extension (IE...
  15. D

    dealing with Read Receipt to find the email address

    I would like to know how could I read the email address from a "read receipt" as the following code isn't working MItem.SenderEmailAddress I have a potential work around but don't know how to code it! The work around would be like this if MItem is not an email then reply to the "read receipt"...
  16. W

    Extracting Email Addresses From Shapes in Excel with VBA

    I am pasting hundreds of items from an external app into an excel sheet. Each item includes an 'envelope' shape which contains the ussers email address (mailto:user.name@address.com). This is the only way you can extract email addresses from this other app. (its an internal app not off the...
  17. J

    Textbox Based On Selected Listbox Rows

    Can someone please help with the following. I have a listbox which is filled with email addresses, I would like a script which once I have selected rows that I want in a multiselect listbox it will then put all the email addresses into a textbox as follows say the listbox has the following...

Watch MrExcel Video

This Week's Hot Topics

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
Top