mymail

This is to copy a range from Excel and send by email. Application.ScreenUpdating = FalseDim Rng As Range Dim xInspect As Object Dim pageEditor As Object Set myApp = New Outlook.Application Set myMail = myApp.CreateItem(olMailItem) Set sh3 = Sheet2 sh3.Unprotect Set Rng =...

Hi everyone, Here i am trying to send multiple attachments at one shot but as i compiled and check its exiting at the point of attachment at the send time Any one suggest me with what changes i should do???? Here is my code Sub Mail() Dim myApp As Outlook.Application, mymail As...

Hello Guru’s I would require your help on below requirement. I am new in VBA script this is my first attempt. Currently am sending mails one by one with manual change in below code. Now I am planning to change code in automation way. I have excel with data as below. <tbody> SNO Name Mail ID...

Context The code below allows or me to send an email once I click submit. It works fine on Microsoft Excel 2010 but gives a 'run time error 287' on Microsoft Excel 2013 - Please help!! :) Dim myApp As Outlook.Application, myMail As Outlook.MailItem Set myApp = New Outlook.Application Set...

I have a code using CDO.message in VBA to send email from excel through Gmail. I can successfully send emails and also attach different files. BUT! 1. I want to be able see/edit email before sending it! If i am not mistaken ".display" does not work for CDO.message. Any other way to get around...

Hi everyone! I am trying to connect excel to gmail via VBA. I did it and macro successfully sends the email. BUT! I want to see and be able to edit the email with attachment if necessary! I know that you cannot display CDO.message but maybe there is a way around/past that ??? Here is my code...

Hi Everyone, I have this Vba that send an email via gmail works great, however in the text body i'd like to add the data from "Sheet Data1 range B5:J15" but make it look like the excel so include the grid So the message would look a bit like this Hi, <tbody> And this...