MS OutLook

In earlier post you have learned how to send Excel Workbook as attachment with email from MS Outlook using Excel. In this article we will learn about how to Send Mail With Multiple Different Attachments From MS Outlook using Excel. These attachments might be anything, an image, word document, excel document, pdf file, text file etc.

Note: Don’t provide any filter in GetOpenFileName() to select any file as attachment.

strFileToOpen = Application.GetOpenFilename(Title:=”Please choose a file to open”)

I would recommend that you must read Send a Simple Mail From MS Outlook Using Excel and how to send Excel Workbook as attachment with email from MS Outlook using Excel to understand the complete code below.

Read moreSend Mail With Multiple Different Attachments From MS Outlook using Excel.

Many a times you need a scenario when you want to send a mail on the daily basis and every new mail contain new image embedded to the mail body, say for example you want to send Good morning message with new image every day.

I would recommend that you must read Send a Simple Mail From MS Outlook Using Excel and how to send Embedded to the mail body from MS Outlook using Excel to understand the basics first if you are new to this.

So how would you do that, there are many different ways to accomplish this, the strategy which I have used here is

• Store all the Images in a folder.
• First time you run your macro, the program will connect to the image folder, take the first image and use it and mark that image as used in our excel.
• Next time when you run the macro, it will see which image is not marked as used, use that. see this picture below.

Read moreExcel-VBA : Send Unique Images Embedded to Mail Body, With Every Mail From MS Outlook using Excel.

In previous articles you have learned about Send a Simple Mail From MS Outlook Using Excel and how to send Attachment With the Mail MS Outlook Using Excel. ( I recommend you first read these articles to understand the basics if you are new to this)

In this tutorial you will learn how to add an image in the mail body or message and send it from Microsoft Outlook.

Ides is to attach the image in hidden manner and later add it to using image name in the HtmlBody.

Read moreExcel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.

In out earlier post we have seen, How to send a simple text mail using MS Excel. In this tutorial we will learn How to send the entire Excel Workbook as attachment along with the mail from Microsoft Outlook using Excel VBA.

Function to add attachment :

olMail.Attachments.Add “File Name”

NOTE: I have used the browse option to make it more real, you can avoid that by directly providing the complete file name as parameter.

To understand the complete Code, Read – How to send a simple text mail using MS Excel

Read moreExcel-VBA : Send a Excel Workbook as Attachment in Mail From MS Outlook Using Excel

In our earlier tutorial we have seen how to send a simple text mail using MS Outlook but how about when you want to send a proper composed mail, means your will compose the mail in a proper format in you excel and you want formatting to be retained while sending.

In that case you will not fetch the text from a excel cell for body, instead you will copy and paste the entire cell into your mail body.

Steps:

• Create object of Outlook Application.
• Create a Mail Item.
• Get the Document Object (for pasting)
• Compose and Send mail using mail Item.

Read moreExcel-VBA : Send a Mail using Predefined Template From MS Outlook Using Excel

This tutorial will teach you about how to send a simple text mail from Microsoft Outlook using excel-macro.

• Create object of Outlook Application.
• Create a Mail Item.
• Compose and Send mail using mail Item.

• Create object of Outlook Application.

Set otlApp = CreateObject("Outlook.Application")

• Create a Mail Item.

Set olMail = otlApp.CreateItem(olMailItem)

Read moreExcel-VBA : Send a Simple Mail From MS Outlook Using Excel