Excel 2010 VBA Tutorial 61 - Sending Emails

[Espadonscominois]

Thanks for this tuto, very well done. Is it possible to send a range of an excelsheet in the body of the mail?

[alanelston]

Hi
Thanks very much for sharing. I am wanting to learn the “Excel VBA – Outlook way” of automating Email sending as a possible alternative to the “CDO Message” way which I have just mastered.
I have the “CDO Message way” working well and I think I understand it.
But I would like an alternative. So I am now trying to learn the “Excel VBA – Outlook way”

As you mention, you need to have a “working” Outlook in order to use this way
I have no experience with Outlook and am just a computer novice.
Can you recommend a good tutorial which will show me how to set up the minimum that I need with Outlook to allow me to use the “Excel VBA – Outlook way”
Thanks
Alan

[OsamaAbdulrahmanS]

thanks i have been looking for this code for a while ....

[TheSashabaw]

If I had a sheet on my workbook with a list of 100 emails on (Sheet2), how would I reference that in the code from the .To area?
 SO that I can send this to a wide audience and not only 1 person

[thomasprevarin]

Dim OutlookOBJ as Outlook.Application
Am I right assuming this piece of code is geared towards creating an application that connect to outlook?

Set OutlookOBJ = New Outlook.Application
This should be to activate the application I've created on the first line of code, is this correct? Is there any alternative ways of using the "Set" command on this example, after the first line of code?

I'm new to VBA and I'm trying to get my head around object variable...

Appreciate your help

[edwinccalle]

Hello Thank you for respond,
Now I have another question. How can I add an image to my email but not as attachment I would like to added as Happy Birthday post so i open the email i can see the post card. I hope don't have confuse you.

Thank you my fried 

[thomasprevarin]

Hi Matt,
Is there any MS Outlook VBA On-Line tutorial?

[LilMel]

Hi! love you tutorials! It's working fine for me but how can you insert multiple lines of text in the body? I need to have my text in English and French; how can you have 2 diff paragraph using VBA?

[jarvisldjl]

Hi! I successfully made the code but do not know how to use it in my spreadsheet.  I tried making the formula/function "=send_Mail" but excel does not recognize it.  My goal is to automatically send email once a certain condition in my excel file is met.  Do you have a video on how to do this?  Thanks in advance!

[jasonma]

is there a way to bypass the window that shows up to remind you the code is trying to send out an email? Or is there a way to automatically click the "allow" button?

[edwinccalle]

Hello my friend, can you tell me how can i add microsoft outlook to the reference VBA i'm runnign microsoft office 2011 and im trying to checkmark the microsoft outlook but for some reason i can see it on the Tools box that you mentioned on the video please help me
Thank you  

[NeerajKumar-kpft]

Is there any tutorial to generate calendar invite using excel VBA

[tomislavdomic]

Hello, How can I send multiple sheets automatically from one excell document to recipients if each sheet contains recipients email in cell A1.

[Hellomadafaka]

this guy is toiling but his subscriber number explains the injustice in world.

[abdessamadjarjini]

Hi, how can I check if the email is sent or not ?

[katiereid]

Is there a way to send macros with this?

[amedeo]

Hi!

what if I were a Lotus Notes user?
Thanks a lot in advance.