email from excel

Good day, we have some code that sends a bulk email from a second email account on a PC, and for some reason we are not able to get this code to use the desired email address. Please see code below. can you see the issue as to why this is sending from the default, not second, email address...

Hi there, first ever post on such a forum, so hope you guys can assist. I am trying to create and then attach a dynamic file to a series of emails. Code below has been cobbled together from other threads and creates the email but without any attachment. Help! Sub Test1() Dim i As Long...

Okay, so Ive read all the threads, and as you'll see in my (other peoples) code, spent some time on Ron's site as well. From that, I have 2 pieces of code working (3 including the function, lets call them C1 and C2), now I need help trying to mend them together. The first one (C1) gets data...

Hello. I am trying to get the below code to run to open an email addressed to email addresses that populate in a cell based on a VLOOKUP. The code is [Private Sub CommandButton21_Click()Sub SendingSheet() Dim oMSOutlook As Object Dim oEmail As Object Set oMSOutlook =...

Hello, this is my first post (I will be following up this post with another). I am Training & Development professional. This project is to design a peer-to-peer training tool in Excel. This will be available on the company's intranet, and will be used by all full time employees. There are 6...

Hi All, Is it possible to send email without outlook support from excel using macro code. Issue: I have two text boxes which will ask the "First Name" and "Second Name" and one command button named as "Submit" When i click the submit button, an email should go to my mail id (Eg: xxx@xyz.com)...

I've referenced Ron DeBruin's articles. I've tried CDO and it seems SMTP is blocked. I've tried sending via Outlook 2007, but can't get past the Outlook dialog asking if I want to allow Excel to send the mail. I've tried using SendKeys at various points. I've examined the gmail example found...

<TABLE style="WIDTH: 442pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=589><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 145pt; mso-width-source: userset...

Hi All, I wanted to trigger an email from an excel tracker. it is working fine if i run the macro manually but i wanted to convert this into automated process. i have added the "Private Sub Workbook_Open()" into the workbook and "Sub Create_Mail_From_List()" on the module 1. unfortunately it...