email address

I have a VBA code to send emails automatically on cell value change. It works perfectly with dummy email addresses in the TO: field, but I want it to send to addresses generated by an IF function. The VBA doesn't like the cell reference because it contains formula. How do I get around it?

Hi All, I have an idea of what I would like the spreadsheet to do however I have ZERO experience with VBA or coding and I've relied heavily on formulas in the past. I've created an example spreadsheet to try to explain what I'm trying to achieve but basically, I'm looking for a spreadsheet...

Hello Excel gurus, I have extracted emails from Outlook to CSV. Sorry if this has been asked before. Column1 (found in A1) Column2 Column3 To: (Address) CC: (Address) BCC: (Address) email1@domainx.com email2@domainy.com email3@domainz.com;email4@domain1.com...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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