email addresses

  1. 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 ';;; Machining ';; Thanks for any...
  2. G

    Automatically email based on cell value

    Hey all - I would like to create a macro that automatically creates an email for a group of people based on a cell value that's selected from a drop-down menu in a range of cells. There would only be 2 or 3 status options from the drop-down menu, but a specific group of people would be emailed...
  3. F

    Trying to scrape emails with VBA

    Hello Ladies & Gents, I am trying to scrape specific emails, but when I look at the source code & when I use my scraper, there seems to be 15 different emails for one email. for i.e. the email is hiding in in a with 15 tags --- and only one contains the email A better example... I am...
  4. F

    Help With Scraping Emails VBA

    Hello All, I am very new to this and I have been taking bits and pieced of codes that I have either found online or on youtube. [+>[SCROOLL TO BOTTOM FOR QUESTION]<+] I want to collect emails from this website: The State Bar of California Home Page I have automated the process to click and...
  5. G

    Send Task from Access to multiple emails from listbox

    Hi I'm fairly new to access so apologies for any newbie language. :eeek: I have a form (frmTasks) that has a listbox (lbAssignedTo) which contains multiple email addresses. I'm trying to figure out how to tell set the TO:(Set ToContact = Task.Recipients.Add) in the task email to the selections...
  6. E

    How can I perform a "Text to columns and Transpose" for a variable # of columns?

    Hello, thanks in advance for your help. I have data exported from Outlook in 3 columns: To (address), To (display), and To (address type) I want to do a text-to-columns and transpose such that each address (separated by a ";" in all three columns) gets it's own row. Easy enough to do if all...
  7. C

    VBA to copy email address from hyperlink and paste in excel

    Hello and thanks in advance. I'm trying to collect email addresses from a bunch of different pages on a web domain and paste it in excel 2013. I'd like the macro to: find the email address on the web page (i have a list of 1,100 hyperlinks in Column A), copy it, and paste it in Column H, for...
  8. N

    VBA Code to export excel file to MS Outlook email as attachment, send and categorize the mail

    Hi Everyone and thanks in advance for the help. I am relatively new to basic but really want to learn. I know I can count on you guys. I do not know how to approach this. I need a macro which can do the following 1. saves excel worksheet to a folder 2. replies to an outlook mail (criteria: the...
  9. T

    Email in VBA

    Hello, I am looking to create an email in VBA through excel that emails only the data associated with the same email address only once. .... For example with the following table: <tbody> Amount Time Person Email 3 14 Tom 2 200 Tom 4 6 Tom 7...
  10. Y

    Using VBA to send personalized emails

    Hi all, Im trying to send emails from an excel spreadsheet. I have names and email addresses in columns A & B. I also have an embedded text box with a generic message. My end goal would be to create send each person and email reading"Dear Name," followed by the text from the text box. I have...
  11. G

    ACCESS VBA code to send email's on Lotus 8.5

    Hi to all; I've this code bellow is to send email's field in access but it only send to the first email only; rst![Email] -->, It can be 1, 2 or more; ---/--- Private Sub Command43_Click() Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Dim rst...
  12. M

    Help modify macro to send 1 email to multiple recipients listed on active sheet

    I found this macro code VBA code to convert excel to pdf and email it as attachment that PDFs an excel sheet, attaches it to an email and sends it out. And it works great. I'm looking for one modification. I want my recipient list to be of email addresses in range B46:B60 that are on a sheet...
  13. A

    Help with EMAIL macro

    Hello everyone, I am new to the forum and am really stuck with this macro. I have searched and found multiple macros regarding emails and have had them work with one exception. The range that i am pulling the emails from has blanks. The list starts in cell BD9 and goes until BD45. The macro...
  14. E

    error on sending email - 2 lines of code i need help on

    i need help on 2 lines of code Sub sendemail(subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olMail As Outlook.MailItem setolmail = olapp.CreateItem(olMailItem) olMail.To =...
  15. E

    mass email i keep getting errors can some1 HELP ?? ? ? CLICK HERE !!

    i keep getting an error can some1 look at this and help me fix this code? or help me with the notes in this code Sub sendemail(what_address As String, subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application")...
  16. S

    Help combining information from 2 sheets

    My hobby business is race photography. We go out and shoot races and then upload them to our servers and then using an excel sheet with first name, last name, bib (race) number, and email address...we are able to upload this into the software to send out automated emails to each participant. A...
  17. S

    Extracting consecutive letters from a cell and applying the IF function

    Hello everyone, First timer here. I'm working on an email database and am looking to sort them into type. I am trying (without success) to use the IF function as follows. If A1 contains the letters "isd" consecutively, then B1=TRUE If A1 contains the letters "google", "yahoo", "hotmail", or...
  18. T

    Creating a hyperlink that has a subject line in the email

    I am creating a yearly report for my company, and I have an email column that we can enter in the individual’s email address in the cell. When we click on the email address it does what it is supposed to do; however, I want to go a step beyond that. I want the email to prefill the subject line...
  19. T

    Email with .Body & .To using Variable for the .To

    I have an email challenge that I have not been able to overcome. I was using Sendmail but could not add anything to the body of the email. I switched over to the method below but have not been able to figure out how to use a variable in the .To instead of an email address. The email addresses...
  20. K

    match part of full name

    I am looking to get a user's email address. On Sheet A (Foreseen Absences) I have users enter their own data. On Sheet B (email addresses) I have users' full names and email addresses. I have the following formula entered on Sheet A to get the user's email address: =vlookup(C173,'email...

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