Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Macro Excel envía mail con Outlook


(adsbygoogle = window.adsbygoogle || []).push({});

El tema de enviar mail con Excel en un tema muy comentado en en foros sobre macros de VBA, anteriormente se ha publicado como enviar un mail con Excel, como crear alertas y enviar mail; macro emite aviso y envía mail a varios destinatarios; pero todas estas macros hacían referencia a configurar directamente el servidor SMTP de Gmail, Yahoo o Hotmail; en este oportunidad voy a mostrar un ejemplo sobre como enviar mail con Excel mediante Outlook.

Antes de seguir recomiendo leer un excelente libro sobre Excel que te ayudará operar las planillas u hojas de cálculo, haz click acá, si quieres aprender sobre Excel, en inglés, entonces debes hacer click here. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

  

El objetivo final del ejemplo aquí presentado, es que a presionar el botón se corre una macro de Excel que envía un mail utilizando Outlook, en la misma codificación está configurado el sujeto y  texto del mensaje; el destinatario es tomado de la celda E3, no obstante se puede incorporar en la codificación directamente, se programó que el código tomara la variable de la celda para facilitar observar su funcionamiento, ya que se envía al mail que se carga en la celda E3, sin necesidad de modificar el código.
El vídeo que sigue muestra una explicación más detallada y gráfica de la macro presentada, recomiendo observar para una más fácil comprensión de la macro; suscribe a nuestra web desde la parte superior derecha de la página ingresando tu mail y a nuestro canal de You Tube para recibir en tu correo vídeos explicativos sobre macros interesantes, como  por ejemplo como copiar varias tablas vinculadas de Excel a Wordcomo ejecutar una macro dependiendo del valor de una celdapasar datos de listbox a hoja de Excelbuscar en listbox mientras escribes en textboxcrear indice a hojas del mismo libro y al menú principalconectar Excel con Access e insertar datos, envio de mail utilizando Outlook y adjuntando una sola hojaenvio de mail mediante Outlook adjuntando todo el libro y como enviar mail con Excel usando Outlook y agregando link hyperlink o hipervinculo y mucho más.

function onYtEvent(payload) {
if (payload.eventType == ‘subscribe’) {
// Add code to handle subscribe event.
} else if (payload.eventType == ‘unsubscribe’) {
// Add code to handle unsubscribe event.
}
if (window.console) { // for debugging only
window.console.log(‘YT event: ‘, payload);
}
}

Al final hay un link del cual podrás descargar el ejemplo y adaptarlo a tus necesidades, el código se encuentra abierto y sin ningún tipo de restricción, te recomiendo descargar el ejemplo y ver su codificación y funcionamiento.

Código que se inserta en un userform

Sub SendMailbyOutlook()
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim OA, OM As Object
Dim TD As String
TD = Format(Date, «ddmmyyyy»)
Set OA = CreateObject(«Outlook.Application»)
OA.Session.logon
Set OM = OA.CREATEITEM(0)
dest = Cells(3, «E»)
With OM
    .To = dest ‘Agregar mail de destino, ejemplo «xxxxx,@gmail.com» (con comillas incluidas)
    .CC = «»
    .BCC = «»
    .Subject = «Resumen de cuenta»
    .Body = «Estimado, el resumen de cuenta se lo enviaremos el » & TD
    .Send
End With

If Err.Number = 0 Then
       SendMail_Gmail = True
       MsgBox «El mail fue enviado con éxito», vbInformation, «AVISO»
Else
       MsgBox «Se produjo el siguiente error: » & Err.Description, vbCritical, «Error nro » & Err.Number
End If
Set OM = Nothing
Set OA = Nothing
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita.


(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.

Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (120)

I am the business owner of JustCBD Store company (justcbdstore.com) and I’m presently looking to grow my wholesale side of business. I really hope that anybody at targetdomain give me some advice . I considered that the most ideal way to accomplish this would be to reach out to vape companies and cbd retail stores. I was hoping if someone could suggest a qualified web site where I can buy Vape Shop B2B Business Data List I am already reviewing creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. On the fence which one would be the most suitable solution and would appreciate any guidance on this. Or would it be much simpler for me to scrape my own leads? Suggestions?

Responder

I truly love your website.. Very nice colors & theme. Did you develop this amazing site yourself? Please reply back as I’m trying to create my own site and want to find out where you got this from or what the theme is called. Appreciate it!

Responder

Nice post. I learn something new and challenging on sites I stumbleupon every day. It’s always helpful to read through content from other authors and use something from their sites.

Responder

Great site you have got here.. It’s hard to find high-quality writing like yours these days. I honestly appreciate individuals like you! Take care!!

Responder

I love looking through a post that will make people think. Also, thank you for permitting me to comment!

Responder

Hi there! This blog post could not be written any better! Looking through this article reminds me of my previous roommate! He always kept talking about this. I will send this post to him. Fairly certain he will have a good read. I appreciate you for sharing!

Responder

After I originally left a comment I appear to have
clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I receive four emails with the exact same comment.

Is there a way you are able to remove me from
that service? Thanks a lot! adreamoftrains
web hosting sites

Responder

bookmarked!!, I like your blog!

Responder

Hi, I do believe this is an excellent website. I stumbledupon it 😉 I will revisit yet again since i have book marked it. Money and freedom is the best way to change, may you be rich and continue to help others.

Responder

Howdy, I do think your blog could possibly be having web browser compatibility problems. When I take a look at your blog in Safari, it looks fine however, if opening in IE, it has some overlapping issues. I simply wanted to provide you with a quick heads up! Aside from that, great blog!

Responder

Good post. I learn something totally new and challenging on blogs I stumbleupon everyday. It’s always helpful to read articles from other authors and use something from their websites.

Responder

Having read this I thought it was extremely enlightening. I appreciate you taking the time and effort to put this article together. I once again find myself spending way too much time both reading and posting comments. But so what, it was still worthwhile!

Responder

I’d like to thank you for the efforts you have put in penning this site. I really hope to view the same high-grade content from you later on as well. In fact, your creative writing abilities has inspired me to get my very own website now 😉

Responder

My brother suggested I may like this web site. He was
once totally right. This post truly made my day.
You cann’t consider just how much time I had spent for
this info! Thanks!

Responder

Achieving your fitness goal does not have to require a certified personal trainer or an expensive gym memberships, it’s not hard to exercise at home. It is easy to go down a training and fitness rabbit hole, however, when you are looking for the best home exercise equipment to outfit your personal home gym.

Responder

I was wondering if you ever considered changing the layout of your blog?
Its very well written; I love what youve got to say.

But maybe you could a little more in the way of content
so people could connect with it better. Youve got an awful lot of text for
only having one or 2 images. Maybe you could space it out better?
cheap flights yynxznuh

Responder

Oh my goodness! Amazing article dude! Thank you, However I am experiencing troubles with your RSS. I don’t understand the reason why I can’t subscribe to it. Is there anybody getting the same RSS problems? Anyone that knows the solution will you kindly respond? Thanx!!

Responder

I wanted to thank you for this very good read!! I absolutely enjoyed every little bit of it. I’ve got you saved as a favorite to look at new things you post…

Responder

Hello, There’s no doubt that your web site may be having web browser compatibility issues. Whenever I look at your web site in Safari, it looks fine however when opening in I.E., it has some overlapping issues. I merely wanted to provide you with a quick heads up! Other than that, wonderful website!

Responder

Sweet blog! I found it while browsing on Yahoo News.
Do you have any tips on how to get listed in Yahoo News?
I’ve been trying for a while but I never seem to get there!
Thanks cheap flights yynxznuh

Responder

This is the perfect site for anyone who hopes to find out about this topic. You know a whole lot its almost tough to argue with you (not that I really would want to…HaHa). You definitely put a new spin on a topic that has been written about for ages. Excellent stuff, just wonderful!

Responder

Thanks for the good writeup. It actually was once a enjoyment
account it. Glance advanced to more delivered agreeable from you!
However, how can we keep up a correspondence? 32hvAj4 cheap flights

Responder

It’s difficult to find educated people on this subject, however, you sound like you know what you’re talking about! Thanks

Responder

hi!,I like your writing very much! share
we communicate extra about your article on AOL?

I need a specialist in this house to unravel my
problem. May be that is you! Having a look forward to peer you.

Responder

Good article. I will be facing some of these issues as well..

Responder

That is a great tip particularly to those fresh to the blogosphere. Brief but very precise information… Many thanks for sharing this one. A must read post!

Responder

There is definately a great deal to know about this subject. I love all of the points you’ve made.

Responder

Macro Excel envía mail con Outlook – PROGRAMAR EN VBA MACROS DE EXCEL
[url=http://www.g6ol9n57hw6x3t22i05ltd29809ckoy7s.org/]udpbxqstzwc[/url]
adpbxqstzwc
dpbxqstzwc http://www.g6ol9n57hw6x3t22i05ltd29809ckoy7s.org/

Responder

You’re so interesting! I do not believe I have read through anything like this before. So nice to discover somebody with some genuine thoughts on this subject matter. Really.. many thanks for starting this up. This website is something that is needed on the internet, someone with a little originality!

Responder

This blog was… how do I say it? Relevant!! Finally I have found something which helped me. Thanks!

Responder

We tested coffee makers for the water temperature during the brew cycle and the brewing time as well as the temperature of the coffee at the end of brewing and during the keep warm cycle. In addition, we evaluated each brewer’s ease of use, including how easy it was to read and use the controls, access the water tank and brew basket, read the markings on the tank and carafe, whether or not it had automatic keep warm and shut off cycles, and the ease of cleaning the carafe.

Responder

I used to be able to find good information from your content.

Responder

I absolutely love your site.. Very nice colors & theme. Did you develop this amazing site yourself? Please reply back as I’m planning to create my own site and want to know where you got this from or what the theme is called. Kudos!

Responder

Oh my goodness! Incredible article dude! Many thanks, However I am experiencing difficulties with your RSS. I don’t understand the reason why I am unable to join it. Is there anybody else getting identical RSS problems? Anyone that knows the answer can you kindly respond? Thanks!!

Responder

After going over a few of the blog articles on your blog, I seriously like your technique of writing a blog. I book marked it to my bookmark site list and will be checking back in the near future. Please check out my website too and let me know what you think.

Responder

You are so interesting! I do not believe I have read through something like this before. So great to discover somebody with some genuine thoughts on this subject. Really.. many thanks for starting this up. This website is one thing that’s needed on the internet, someone with some originality!

Responder

Macro Excel envía mail con Outlook – PROGRAMAR EN VBA MACROS DE EXCEL
avqsfeyplsp
[url=http://www.g9y53615a82hcud40p6o6bez3ux4tb60s.org/]uvqsfeyplsp[/url]
vqsfeyplsp http://www.g9y53615a82hcud40p6o6bez3ux4tb60s.org/

Responder

An impressive share! I’ve just forwarded this onto a colleague who was conducting a little homework on this. And he actually ordered me dinner simply because I discovered it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to talk about this topic here on your website.

Responder

Throughout this awesome design of things you’ll receive an A with regard to hard work. Where you lost me personally ended up being in the particulars. You know, they say, the devil is in the details… And that couldn’t be more true right here. Having said that, let me reveal to you just what did give good results. The authoring is certainly rather powerful which is possibly why I am taking an effort in order to comment. I do not make it a regular habit of doing that. Next, whilst I can notice a jumps in reason you come up with, I am definitely not confident of how you appear to unite your points which produce the actual conclusion. For now I shall subscribe to your position but wish in the future you connect the dots much better.

Responder

The next time I read a blog, Hopefully it doesn’t disappoint me just as much as this one. After all, I know it was my choice to read, nonetheless I actually believed you would probably have something useful to talk about. All I hear is a bunch of crying about something you could possibly fix if you weren’t too busy searching for attention.

Responder

I appreciate, cause I discovered just what I was looking for.
You have ended my four day long hunt! God Bless you man. Have a nice day.

Bye

Responder

This site certainly has all of the information I needed concerning this subject and didn’t know who to ask.

Responder

I have not checked in here for a while since I thought it was getting boring, but the last several posts are great quality so I guess I will add you back to my everyday bloglist. You deserve it my friend 🙂

Responder

I blog often and I genuinely appreciate your information. This article has really peaked my interest. I will book mark your blog and keep checking for new details about once per week. I subscribed to your Feed too.

Responder

Commit your work to the Lord, and your plans will be established. Proverbs 16:3 ESV

Responder

Hi there! This post couldn’t be written much better! Going through this article reminds me of my previous roommate! He constantly kept preaching about this. I will send this information to him. Fairly certain he’s going to have a good read. Many thanks for sharing!

Responder

I blog quite often and I really thank you for your content. This article has really peaked my interest. I am going to bookmark your website and keep checking for new information about once a week. I subscribed to your RSS feed too.

Responder

I simply wanted to give you a quick heads up! Aside from that, excellent blog!|

Responder

After checking out a number of the blog articles on your website, I honestly appreciate your way of writing a blog. I saved as a favorite it to my bookmark webpage list and will be checking back in the near future. Please visit my web site as well and let me know what you think.

Responder

I could not refrain from commenting. Perfectly written!

Responder

I’m really impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you customize it yourself? Anyway keep up the nice quality writing, it’s rare to see a great blog like this one nowadays..

Responder

I blog quite often and I truly appreciate your information. The article has truly peaked my interest. I am going to book mark your site and keep checking for new details about once per week. I opted in for your RSS feed too.

Responder

An impressive share, I just given this onto a colleague who was doing slightly evaluation on this. And he in reality purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to debate this, I really feel strongly about it and love reading extra on this topic. If attainable, as you turn out to be experience, would you thoughts updating your blog with extra details? It is extremely useful for me. Large thumb up for this weblog put up!

Responder

I’d like to thank you for the efforts you have put in writing this blog. I am hoping to see the same high-grade blog posts from you in the future as well. In truth, your creative writing abilities has motivated me to get my very own blog now 😉

Responder

Hello, There’s no doubt that your website could possibly be having browser compatibility problems. When I look at your site in Safari, it looks fine however when opening in IE, it has some overlapping issues. I simply wanted to give you a quick heads up! Apart from that, fantastic website!

Responder

Good post. I am dealing with many of these issues as well..

Responder

A crime eats its own child. Sechuana

Responder

Hello! I could have sworn I’ve been to your blog before but after looking at some of the posts I realized it’s new to me. Anyhow, I’m definitely happy I found it and I’ll be bookmarking it and checking back regularly!

Responder

Why keep a dog and bark yourself?

Responder

I needed to thank you for this very good read!! I definitely enjoyed every bit of it. I have got you saved as a favorite to check out new things you post…

Responder

Excellent site you have here but I was curious about if you knew of any discussion boards that cover the same topics talked about in this article? I’d really love to be a part of community where I can get comments from other knowledgeable people that share the same interest. If you have any suggestions, please let me know. Cheers!

Responder

I havenít checked in here for a while since I thought it was getting boring, but the last few posts are good quality so I guess Iíll add you back to my everyday bloglist. You deserve it my friend 🙂

Responder

It’s actually a cool and helpful piece of info. I’m satisfied that you shared this useful information with us. Please stay us informed like this. Thanks for sharing.

Responder

I’m impressed, I have to admit. Seldom do I encounter a blog that’s equally educative and entertaining, and without a doubt, you’ve hit the nail on the head. The issue is something that too few men and women are speaking intelligently about. Now i’m very happy that I found this during my hunt for something relating to this.

Responder

Your style is unique in comparison to other folks I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I will just book mark this blog.

Responder

Excellent post. I was checking continuously this blog and I’m impressed! Very useful information specifically the last part 🙂 I care for such info much. I was seeking this particular info for a long time. Thank you and good luck.

Responder

A person necessarily lend a hand to make significantly posts I’d state. That is the first time I frequented your website page and up to now? I surprised with the analysis you made to create this particular put up amazing. Fantastic task!

Responder

Great post! We will be linking to this great article on our website. Keep up the good writing.

Responder

Excellent read, I just passed this onto a colleague who was doing some research on that. And he actually bought me lunch since I found it for him smile So let me rephrase that: Thank you for lunch!

Responder

Great post. I’m going through many of these issues as well..

Responder

Heya i am for the first time here. I found this board and I find It truly useful & it helped me out a lot. I hope to give something back and help others like you helped me.

Responder

Hi! I simply would like to give you a huge thumbs up for the excellent info you’ve got here on this post. I will be returning to your site for more soon.

Responder

I needed to put you that very little remark in order to give thanks yet again for the spectacular solutions you’ve discussed above. It was unbelievably open-handed with people like you to present freely all that a lot of folks would’ve offered for an ebook to help make some cash for their own end, particularly since you might well have done it if you ever desired. The tips in addition worked to be the great way to fully grasp that other people online have a similar dreams really like my personal own to know the truth many more with reference to this problem. I’m certain there are numerous more enjoyable occasions ahead for individuals that browse through your site.

Responder

Want is the mother of industry.

Responder

You are so interesting! I don’t believe I’ve read a single thing like this before. So wonderful to find somebody with a few genuine thoughts on this subject matter. Really.. thanks for starting this up. This web site is something that is needed on the web, someone with a bit of originality!

Responder

I know this if off topic but I’m looking into starting my own weblog and was curious what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100 positive. Any recommendations or advice would be greatly appreciated. Cheers

Responder

Good post. I learn something totally new and challenging on blogs I stumbleupon on a daily basis. It will always be interesting to read content from other authors and practice a little something from other websites.

Responder

Having read this I believed it was rather informative. I appreciate you spending some time and energy to put this article together. I once again find myself spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

Responder

Hey very nice web site!! Man .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also…I’m happy to find a lot of useful info here in the post, we need develop more strategies in this regard, thanks for sharing. . . . . .

Responder

Just desire to say your article is as astonishing. The clarity in your post is simply excellent and i can assume you’re an expert on this subject. Fine with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the gratifying work.

Responder

This is really interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your excellent post. Also, I’ve shared your site in my social networks!

Responder

I seriously love your site.. Very nice colors & theme. Did you create this amazing site yourself? Please reply back as I’m planning to create my own personal site and want to learn where you got this from or just what the theme is called. Thank you!

Responder

Great info. Lucky me I ran across your site by chance (stumbleupon). I have bookmarked it for later!

Responder

So Great! I need some infos in this post for my rapport de stage. Can i have your contact please? I need your permission to quote it . Anyway, That’s great job. Keep going.

Responder

I want to to thank you for this fantastic read!! I absolutely loved every bit of it. I’ve got you book-marked to look at new things you post…

Responder

You made some decent points there. I checked on the net to find out more about the issue and found most people will go along with your views on this site.

Responder

I like reading through and I conceive this website got some really utilitarian stuff on it! .

Responder

Based on my research, after a property foreclosure home is bought at an auction, it is common for any borrower to be able to still have any remaining balance on the mortgage loan. There are many lenders who try to have all costs and liens cleared by the following buyer. On the other hand, depending on particular programs, laws, and state guidelines there may be several loans which are not easily resolved through the shift of lending options. Therefore, the duty still rests on the lender that has received his or her property in foreclosure. Many thanks sharing your notions on this site.

Responder

Very good article! We will be linking to this particularly great content on our site. Keep up the good writing.

Responder

Pretty! This was a really wonderful article. Many thanks for supplying this information.

Responder

I’m really enjoying the theme/design of your web site. Do you ever run into any browser compatibility problems? A number of my blog audience have complained about my site not operating correctly in Explorer but looks great in Safari. Do you have any tips to help fix this problem?

Responder

I used to be able to find good info from your articles.

Responder

Yesterday, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 25 foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is completely off topic but I had to share it with someone!

Responder

An fascinating discussion is price comment. I think that you need to write more on this subject, it won’t be a taboo subject but usually persons are not enough to talk on such topics. To the next. Cheers

Responder

This is a topic which is close to my heart… Cheers! Where are your contact details though?

Responder

Thank you for your blog post.Really thank you! Awesome.generico do viagra sandoz

Responder

I am curious to find out what blog platform you have been utilizing? I’m experiencing some small security issues with my latest blog and I’d like to find something more safeguarded. Do you have any suggestions?

Responder

you have an excellent weblog here! would you like to make some invite posts on my weblog?

Responder

Very good post. I absolutely love this site. Thanks!

Responder

Spot on with this write-up, I honestly think this web site needs a great deal more attention. I’ll probably be back again to see more, thanks for the information!

Responder

Once I initially commented I clicked the -Notify me when new feedback are added- checkbox and now every time a remark is added I get four emails with the identical comment. Is there any way you’ll be able to remove me from that service? Thanks!

Responder

whoah this blog is great i really like studying your posts. Keep up the great work! You recognize, a lot of individuals are searching around for this information, you can aid them greatly.

Responder

There are actually a lot of particulars like that to take into consideration. That could be a nice level to deliver up. I supply the thoughts above as general inspiration but clearly there are questions just like the one you bring up the place a very powerful factor will likely be working in honest good faith. I don?t know if best practices have emerged round issues like that, however I am sure that your job is clearly identified as a fair game. Each girls and boys really feel the impact of just a moment’s pleasure, for the rest of their lives.

Responder

After reading your blog post I browsed your website a bit and noticed you aren’t ranking nearly as well in Google as you could be. I possess a handful of blogs myself and I think you should take a look on it. You’ll find it’s a very nice tool that can bring you a lot more visitors. Keep up the quality posts

Responder

Hey There. I discovered your blog the usage of msn. That is a very neatly written article. I’ll make sure to bookmark it and come back to read extra of your useful information. Thank you for the post. I’ll definitely return.

Responder

I absolutely love your website.. Very nice colors & theme. Did you make this amazing site yourself? Please reply back as I’m hoping to create my own personal site and want to know where you got this from or what the theme is called. Thanks!

Responder

hey there and thank you on your info – I’ve definitely picked up something new from proper here. I did on the other hand experience a few technical points using this web site, since I experienced to reload the web site lots of instances prior to I could get it to load properly. I were thinking about in case your web hosting is OK? No longer that I am complaining, however slow loading circumstances times will sometimes have an effect on your placement in google and can harm your high-quality score if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Well I’m including this RSS to my email and could look out for much more of your respective interesting content. Ensure that you replace this once more soon..

Responder

Pretty! This was an extremely wonderful post. Thanks for providing these details.

Responder

Thanks for every other informative site. The place else may just I get that kind of information written in such a perfect means? I have a undertaking that I am just now running on, and I’ve been at the glance out for such info.

Responder