VBA macro to send a email to one of a list of emails



VBA macro to send to one of a list of emails. send emails from excel. Use vlookup in a macro. Send email based on location selected
Check out my online courses

For more help visit my website or email me at easyexcelanswers@gmail.com.

Contact me regarding customizing this template for your needs.

Click for online Excel Consulting

I am able to provide online help on your computer at a reasonable rate.

Check out my next one-hour Excel Webinar

I use a Blue condensor Microphone to record my videos, here is the link

Check out Crowdcast for creating your webinars

If you need to buy Office 2019 follow

I use Tube Buddy to help promote my videos
Check them out

Follow me on Facebook

TWEET THIS VIDEO

Follow me on twitter
easyexcelanswers

IG @barbhendersonconsulting

You can help and generate a translation to you own language

*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
guest
6 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Héctor Rivera

Hi, I would like to know what happen if I have two email addresse with the same location?

Arnulfo Ortega

Good morning! Got lost on the part were you create the PDF last sentences open as true…

davidfunvideos

in the set command "set outlookmailitem = ourlookapp.createitem(0)"
is "createitem(0)" part of the statement always going to zero?
For instant if you want to loop though a set of email address and send them difrent reports would you need to change the 0 to a 1 etc?

YJ L.

Thanks for your Video, dose it work on Excel 2007?

Barb Henderson

here us a link to a video that I have seen on this
https://www.youtube.com/watch?v=pFl7W8d7d4M&t=290s

Meni Porat

Can you please explain how to send an email via Gmail?
Thank you.