e-mail

Hi, I'm trying to click a hyperlink that will open a new e-mail with Outlook and the e-mail would be all filled with values from Excel cells. Here's what I got so far: =HYPERLINK("mailto:" & R1530 & "?subject="& CONCATENATE(A1530," ",B1530) & "&body=" & CONCATENATE("HI","YO",C1530)&"hello"...

Hi, I am very new to VBA Code and am struggling to achieve adding an Excel 2010 workbook (or even Active Worksheet) to an e-mail using VBA and wondered if anyone could help? So I've created a form in Excel 2010 which I want colleagues to complete. When they've done that, I'd like them to be...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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