e-mail

  1. E

    Comparing Data in Two Columns

    I have two columns of data in Column A and B. In column A, each cell could contain one to ten e-mail addresses. In Column B, each cell could contain one to ten e-mail addresses that could be the same or different. So A1 could be as@hotmail.com, as@gmail.com, as@yahoo.com B1 could be...
  2. V

    VBA Code to e-mail selection syntax

    Good Afternoon, I have tailored the following code to enable me to e-mail a selection in my workbook to specified people at the push of a button: With ActiveSheet.MailEnvelope .Introduction = "These are the items Due or Late for Calibration - please review your items and confirm they...
  3. W

    Do not ignore duplicate email addresses for VBA

    In this code, the script will exclude duplicate email addresses. I want the opposite, as I want to include duplicate email addresses and send them each a separate e-mail. I do not know what part of the code to modify to get the intended result. '--- Begin looping through all the e-mail...
  4. B

    [VBA/Macro/ How do I copy a range of cells and then paste that data in the CURRENT e-mail you are in on Outlook?

    Hi fellow coders, I currently have a Macro that copies a specific range of cells and, with a click of a button (titled: Send E-mail), opens Microsoft Outlook with a new e-mail message with the information pasted in the body. This is what I want to do: 1) In Microsoft Outlook, search for...
  5. C

    Assign e-mail address based on PDF name from outlook attachment

    Hi all, my name is Constantin and I am mostly guest reading in this forum. Thanks for alle the help so far. At the moment I am trying set up a macro to send different PDFs automatically to different recipients. I have a Folder with all pdfs in it and a Excel list with filename and a...
  6. M

    Excel Macro

    Hi I want to create a Macro that Import the E-Mail Addresses from Outlook, only the E-Mail that have a concerted Subject "Subscribe for example". I am new at VBA and have to compete this missin in my Job. I have ried to insert the code in Outlook macro, but i could't find the Action " run a...
  7. O

    VBA - Group by value in table and send e-mail

    I have a large list where I have different companies and organisations. My current VBA codes iterates through each table row, and send out an e-mail for each line. However, what I need to achieve is that there might be companies which have the same parent organisation - in this case, I don't...
  8. U

    Excel Macro For e-mailing Prices

    Good morning all, I was under the impression that if I recorded a macro using excel it would also record actions made in other Office programs, am I wrong? I have seven different price bands which each have specific customers assigned to them. Currently I have to open up seven separate e-mail...
  9. M

    Attach File to Hyperlink Mailto

    Is there a function or command that will attach a completed worksheet as a file in an e-mail note when a hyperlink is on the worksheet with the mailto:anyone@hotmailcom filled in as the hyperlink? I'm trying to have a user complete a worksheet, click on the embedded hyperlink that opens an...
  10. A

    VBA - Mail whole workbook to multiple people seperately

    Hello Hello Excel Geniuses I have found MANY answers to the first part of my problem..... I would like to email my full workbook to multiple users [solved] BUT...I would like to e-mail it to each individual separately..... the below is working for multiple and 1 e-mail recipient if you are...
  11. S

    Adding Contacts in Outlook Code Problem

    I have the following code that is linked to a button in my tool bar. The problem I am having is when I click the button, a new e-mail opens instead of using the email im writing. what do I have to do to keep it in my current email and make sure that it does not erase my contacts I have already...
  12. N

    Auto Send a Recurring Email

    Hi there, I am trying to write a code and I actually need help to conclude it. I am using a code in order to program my outlook to send a recurring e-mail. The problem is: we have a plug-in installed in our outlook that, before sending the e-mail, pops-up window that we need to press "OK"...
  13. L

    VBA error - reporting the line of problem code???

    Hi I currently have a VBA project within a sheet that is password-protected so that my users cannot tamper with it. If there is a problem with the code, it doesn't show the line of code in yellow for obvious reasons that the project is protected. What I'd like to do is to create a macro that...
  14. C

    prompt help message prompt where user can input e-mail text

    Hi, I have a document that several users are going to use. I have a sheet called "Information" that I uses as a form of homepage. I have a commandbutton called "Help" in this sheet. Is it possible to prompt a message box that functions as seen on some homepages where the user is asked to...
  15. C

    open excel with macro via outlook and pass on a parameter to the macro

    Hi All, I created a userform on excel to manage and track deliverable/tasks. Currently, tool assigns the task to a certain e-mail distribution but we wanted to take one step further and assign the tasks to an individual (after it gets assigned to the group). Easy enough, I can create a form...
  16. M

    sending gmail via excel vba

    Hi all, Just following up on an earlier post with a different question. I have managed to get excel to send an e-mail via gmail thanks to some great advice from Redbeard. I think a new post may now be more appropriate. My other questions associated with this process are: 1. Is it possible to...
  17. M

    Transport error setting up Gmail in excel

    Hi experts, I have not seen a solution to my problem anywhere, I am trying to setup an e-mail in excel using Gmail and it fails with the message "The transport error code was 0x80040217" Username and password is correct in real version. Do I need to somehow add the server name with 'Mail.Send'...
  18. R

    Auto-send Email with column header within message

    Hello, I'm trying to have an email automatically sent using vba code. When an option is selected on a spreadsheet. What i would like is for the code to use the cell it is selected in to then look at the header to include this header in the message. I've seen various coding for this but nothing...
  19. K

    MS Access sending e-mail

    Current process is selecting individuals manually to send e-mail. I'd like to use Access to somewhat automate the process to send static e-mail (except for date update) to different individuals. I have 4 tables set up: tblDate - contains calendar thru 12/31/2025 tblEmail - would contain...
  20. B

    E-mail Address Hyperlink & Cell Reference

    Hi, Iv'e got a helper column which produces an e-mail address in the cell A1 using the formula: =VLOOKUP(E9,A2:BI430,6,FALSE) In another cell I have: =HYPERLINK(A1) It produces a linked cell with the correct email, but when I click it I get the message: "Cannot Open The Specified File". Can...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top