objoutlook

Hello, I am getting he following error when trying to run this macro. Can someone help me correct it. "Compile error User-defined type not defined" The purpose of the vba is to email the latest file from a shared location Option Explicit Sub GenerateEmail() Dim objOutLook As Object...

Greetings I have below code open Outlook from Excel, pull an email address to BCC field, subject and some contents. What changes are required to pull multiple emails from cells B12:B18, B21:22, B29, B32 and B35 to the BCC field? Also, is it possible to pull across a Richtext formatted email I...

Hi! VBA to send auto mail by extracting mail address from worksheet, BUT Not able to extract address from the whole column. It works - but on single cell if I write Range ("A1"). Pls. suggest the correction to be done (I think it should be in - marked as Red) Option Explicit Private Sub...

Can anyone gives a cue what's the error / how to get out of it. Option Explicit Private Sub CommandButton1_Click() On Error GoTo ErrHandler ' SET Outlook APPLICATION OBJECT. Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application") ' CREATE EMAIL OBJECT. Dim objEmail As...

Pls. help I am getting error as variable not defined for olMailItem in below VBA Option Explicit Private Sub CommandButton1_Click() On Error GoTo ErrHandler ' SET Outlook APPLICATION OBJECT. Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application")...

I am trying to add Cell E5 in the body of the email below E4. I am new using VBA. This is what I have so far. Sub CreateEmail() Dim objOutlook As Object Dim objMail As Object Dim rngTo As Range Dim rngSubject As Range Dim rngBody As Range Set objOutlook = CreateObject("Outlook.Application") Set...

Hi everyone A right newbie here so please take it easy on me! I've been using the below code to do a tailored mail merge with specific attachments to my recipients. There will be varied mailing, where some people will receive 1 attachment, and some with 3 for example. The problem that I have...