email addresses

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

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

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

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

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

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

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

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

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 Tom@gmail.com 2 200 Tom Tom@gmail.com 4 6 Tom Tom@gmail.com 7...

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

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] --> test@test.com,test@test2.com It can be 1, 2 or more; ---/--- Private Sub Command43_Click() Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Dim rst...

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

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

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

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

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

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

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

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

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