email addresses

Happy New Year, Excel folks. Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon. Mouse, Mickey <mickey.mouse@d.com>; Microsoft Outlook has changed the way that email addresses from...

On my excel userform I have two list boxes, one with peoples names and this transfers their email address into listbox2, which has multiselect activated, with a command button. That works fine. I would like to know, in really simple coding :), how to convert the Listbox2 results into an array...

Just found out I can send a worksheet as PDF via email by using the home button. however does anyone know if there is a way of automatically putting the email address on the worksheet into the email to save copying and pasting from the sheet??? Thanks Mark

HI, I am a new member to MrExcel and could really use some expert advice. Okay so what I am trying to accomplish... I have an excel spreadsheet with column A displaying names ie:(Josh Smith) Then in column B I have their corresponding email address ie: Josh.smith@aol.com Furthermore, I have...

I wanted users to enter an email address they wanted to email the worksheet to, therefore I created a form and for the send button I had the following code : Private Sub CommandButton1_Click() Dim wb As Workbook Set wb = ActiveWorkbook If Val(Application.Version) >= 12 Then If wb.FileFormat =...