How To Send Outlook Emails From Excel Using VBA For Beginners + FREE TEMPLATE

preview_player
Показать описание

In this step-by-step tutorial I will show you how you can create emails very easily with Excel and VBA. I will also show you how you can loop through contacts, creating dynamic emails with 1 button.

⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:

EXCEL COURSES:

EXCEL PRODUCTS:


Timestamps:
0:00 – Introduction
2:56 – Create Standard Email
9:30 – Send Contact Emails

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#vba #excelvba #Vbaforbeginners #Excelforfreelancers #ExcelEmail #OutlookEmails, #VBAEmail #EmailExcel
Рекомендации по теме
Комментарии
Автор

I think I am in the right place to say that I watched that video with a huge smile on my face hahaha Thank you ! ! ! !

droidfan
Автор

Randy thanks for all the great work you do, I am old and probably never have a need for any of the trainings but memory issues these days make it necessary that I challenge my brain as much as possible with something that requires me to think how and why did he do that or trying to contemplate what you are going to do next when designing VBA. It had to be something I am interested in but didn't understand so it would force me to use my brain to help with exercising it. Believe it or not it has helped. Again thanks may not benefit anyone else but has helped me keep active.

glennclever
Автор

Very useful code. I have been using this method for a while. One point though if you have multiple accounts in outlook then you will need a method to send the email from a particular account.

keithturner
Автор

That's very nice, I once created something like that with a Power Automate + Excel 365 (Sharepoint) version.. That combo worked a bit slow though, it took around 1 hour to send 80 emails, but the email content was much more complicated. Could you make an extended version of your VBA+Outlook solution adding more options to the email? For example, how to attach a unique invoice to each contact, add some other file, make a picture inside email body etc

andrdem
Автор

Hi Randy,
I do not use MS Outlook for my email.
So could you write and share the VBA code to create and send them with Gmail.
Thank you for your kindness and sharing all your knowledge with us. 👋👌

robbe
Автор

Can you please add code for adding individual attachments from colum E. Thanks a lot

ericvanreck
Автор

If I want to share a workbook with others, I use a single line of code to send an email and include the workbook as an attachment:

arg1:="email address goes here", arg2:="subject line goes here"

smithmtodd
Автор

Hello Randy,
I hope you are having a nice day. Looking forward to seeing this video again. Can't

henkvinck
Автор

Hi from france i can't download excel trainning. tanks for your's basic vba trainning

joseviolante-tspv
Автор

Do you just do vba or are you doing python stuff in the future?

Dexterx
Автор

Thank you Randy!
Amazing video as usual.
Is there a reason for declaring dim for every variable?

ranilan
Автор

I'm wondering, what's the benefit of this over using SMTP? If you have an html signature you can inject the html in it and do exactly the same without ever leaving excel.

christobacon
Автор

Hi Randy, can you make videos of SAP tool automation.

PraveenKumar-ilkn
Автор

Is there a way to send the email from another email that is not your own? For example if you are working for someone and you want to send from the company email.

IvyPlans
Автор

What about the New Outlook. I doesnt seem to work with the New Outlook.. 😢

ProHack_GR
Автор

There is a missing in tool reference Microsoft Outlook 16.0 in VBA. How to add an alternative or name change of it. How to do? I want to do it through coding and send messages from Outlook.

ajazkhan
Автор

i am getting an error 429. "activex component cannot create object" any help? the line of error is "Set OutApp =

muhammadmuavia