newmail

Hi Good morning, please can you help me i have a macro to send an email and for the subject i want to add the text in the textbox2 into the subject heading i have done this in the code below but get an error please can you help? With NewMail .Subject = "Late Outage request - " &...

I have tried for 3 days to get this to work. PLEASE HELP ME Sub SendEmailUsingYahoo() On Error GoTo Err Dim NewMail As Object Dim mailConfig As Object Dim fields As Variant Dim msConfigURL As String Set NewMail = CreateObject("CDO.Message") Set mailConfig =...

HI All, good morning, i have this code below which works but at the moment it sends the email from the cells in active sheet, and i want it to send the emails from my range in sheet 2 for example the .To i want to send from sheet 2 and B1, and at the moment i have named my range to screenshot...

Hi, I am a bit stuck and was wondering if anyone has any ideas. I have an extract from Exchange that has data similar to this..lots of rows but need a formula that searches each row for "*newmail.com" and appears in the NEWMAIL column (C): <colgroup><col width="75" style="width: 56pt...

Hi, I am trying to build a routine that will allow me to send an e-mail in Excel via my work gmail account, but I keep receiving the following error: "Could be no internet connection! The transport failed to connect to the server." Our local IT team gave me these Gmail config settings: SMTP...

Let me start by saying that I am in NO WAY a programmer, and that I'm trying to learn as I go. I'm trying to piece together some VB to send emails in Excel with CDO / SMTP. The general Idea is: 1. Populate data throughout the day 2. At the end of shift, Press email button 3. Look at Table1...