email adderss

  1. Z

    Extract email and remove spaces

    Hi, I have below that have "email / name". Is there any way that I can remove the names and the extra space below each email and keep only emails? Email/NameExpected Resultsa@abc.com / A b@abc.com / Ba@abc.com b@abc.coma@abc.com / A f@abc.com / Fa@abc.com f@abc.comd@abc.com / D e@abc.com /...
  2. B

    sending email to multiple addresses based on a cell value

    Hi, I presently have coding that will allow me to send an email template to multiple recipients based on a cell value in a column. My issue is that I am trying to duplicate the same process for a value in a different column and it the email addresses do not populate in the BCC filed of the...
  3. D

    Extract email address from one cell and put the address into another cell

    Hello - I have a spreadsheet where column A is a paragraph of text such as: sent to: abc@xyx.com received from: 1234@myco.com Text here.... or sometimes the cell has contents such as: sent to: xxx@ourcompanycom received from: xxx@mail.com Hello, I am looking for.. and so on. Looking for...
  4. E

    I need help big time! ! ! Click here to help me !

    <tbody> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> column letters BA BB BC BD BE BF...
  5. E

    help plz this should be fast and easy for you!!!

    ok i have a sheet that looks like this and all i want it to do is this... <tbody> frist date of birth email jan. feb mar apr may jun jul aug sep oct nov dec eric 1/30/1986 eric86vabeach@yahoo.com *read note* bob 2/15/1990 bob@bob.com *read note </tbody> ok in cell...
  6. N

    How to take care of empty cells in Excell

    Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty then it gives error.. how to take care of empty cells?? Function SendMail() Dim y As String y = Sheets(1).Range("A1:A10").Value ' Copy the...
  7. L

    Allow only email address format in Excel cell

    How do I allow only email address format to be entered into an Excel 2007 cell?
  8. B

    email using user form

    I have a userform with three 2 textboxes, textbox 1 = subject, textbox 2 = body of email and a command button to send the email. I want users to be able to send an email to my email (myemail@email.com) (for reporting problems with workbook). If I have to I don't have to use a userform. I...
  9. D

    Email send not working with To and CC

    This code works beautifully when there is email addresses in the CC field, but when there is no value in the CC field than an error code 2295 pops up stating unknown message recipient. I need help with what I think should be a conditional snippet: if Me.CC = " ", then Me.From only else Me.From...
  10. A

    Multiple Email Address Validation

    Is there a way to validate more than one email address when entered into an Application.InputBox? EXAMPLE: The user can enter just one email address like: test@test.com or the user can enter multiple email addresses like: test@test.com;test2@test.com Below is a sweet script I found that will...

Watch MrExcel Video

Learn Excel - Pivot From Many Sheets: Podcast #1331

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