How to automate email using VBA. Create dynamic, responsive and mobile-friendly content

Подписаться 51 тыс.

Просмотров 9 тыс.

50% 1

Real-life VBA Project to automate email using VBA. Email To, CC, BCC, Send on behalf, Attachments, the table in the email body, dynamic table, insert image, logo, email without VBA etc.
Create dynamic, responsive and mobile-friendly content.
Additional resources:
www.w3schools.com/html/html_c...
divtable.com/table-styler/
www.html.am/html-editors/onli...
my.stripo.email/
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 35

@VBAA2Z 4 года назад

Friends - project/materials used within the tutorial have been uploaded. Please check the video description for link. If you have any doubt or query, please comment below. Have a great week ahead! :) Cheers!

@djunabug 4 года назад

Lung! You’re a genius! Every one of your videos is absolutely amazing. Not only for the particular technique pitched in the thumbnail, but for heaps of general, extremely helpful coding tips as well. Most VBA videos I’ll watch at upped speed. For yours I’m driven to execute multiple slo-mo replays. That’s high-praise, not a complaint! Keep it up!!

@VBAA2Z 4 года назад

Glad you like them! thanks for your compliment.

@yunminho21 5 месяцев назад

정말 좋은 영상입니다. 항상 응원합니다. 감사합니다.

@VBAA2Z 5 месяцев назад

Thank you!

@scottansir7708 3 года назад

Amazing content as always. You're the man

@VBAA2Z 3 года назад

I appreciate that!

@kylegurtowski5012 4 года назад

Awesome, thanks so much!

@VBAA2Z 4 года назад

No problem!

@bnancy3699 4 года назад

You're the best. thank you

@VBAA2Z 4 года назад

Thanks for your kind words.

@sufiyansiddiqui3061 4 года назад

These are very useful sir Thank you so much for your videos

@VBAA2Z 4 года назад

Thanks Sufiyan. Appreciate your kind words.

@purushothamd6219 3 года назад

U are there to support us to learn something new, we are there to support you always thanks ton☺️

@VBAA2Z 3 года назад

I appreciate that!

@paulomendes1887 2 года назад

Very good, I need this solution.

@VBAA2Z 2 года назад

thanks. Please check video desc. for more info

@weechungsoon 4 года назад

Hope to have vba tutorials to collect data from outlook.

@VBAA2Z 4 года назад

Sure I'll cover that.

@JonathanExcels 4 года назад

I did the early binding step (double checked that Outlook 16.0 Object Library is referenced). I only used the following between the With and End with .To="email.address" .Subject="my text" .Body="text" .Send It errors out on the .Send line. "Application defined or object defined error". my Dim and Set statements are identical to yours at 13:10 if I use .Save instead, then I can see the item in my drafts folder. I can open the draft and hit the send button and it works fine.

@VBAA2Z 4 года назад

Are you sure you didn't missed out defining some objects? for example like below. Feel free to email me/post here the entire code I can quickly check it for you. Set outMail = OutApp.CreateItem(olMailItem)

@JonathanExcels 4 года назад

@@VBAA2Z here is my code. Option Explicit Option Private Module Sub Send_eMail() Dim outApp As New Outlook.Application Dim outMail As Outlook.MailItem Set outMail = outApp.CreateItem(olMailItem) With outMail .To = "firstname.lastname@myemail.com" .Subject = "file was used" .Body = "my text" .Send End With Set outApp = Nothing Set outMail = Nothing End Sub

@JonathanExcels 4 года назад

@vba a2z Any thoughts as to why it isn't working for me?

@sefaelmas8501 4 года назад

thanks for sharing. which is the user authorization panel. can we make stock tracking program. using userform.

@VBAA2Z 4 года назад

Hi Sefa, if you're planning to build a dashboard to show stats in UserForm you can go ahead but interactive charts/graphs will be better in BI tools. Stock tracking program can definitely be built using VBA too. All the best!

@sefaelmas8501 4 года назад

VBA A2Z The user interfaces you have developed are very nice. Can you share an interface example in stock tracking

@rajvenkat3641 3 года назад

Can't find the exact link to download this video VBA code ...pls paste here

@irinkhan8114 Год назад

When my email id is wrong (i.e, not found in mail address book),the macro stops running. What can be done to prevent thia as this prevents from sending my others mails to users in the same column??

@VBAA2Z Год назад

for email automation please check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ji2jHz8YPq8.html

@DavidM_ 3 года назад

13:37 do you actually know how to deal with that error message with permissions? Some people have their main accounts in outlook with additional generic mail accounts and they receive that message when they are trying to send the mail from the generic mail by using vba. But wtihout using vba sending these mails works fine.

@VBAA2Z 3 года назад

as long as the email account is added / set up in Outlook you can use this method SentOnBehalfOfName

@DavidM_ 3 года назад

@@VBAA2Z didn't work. The solution when there are more than one accounts is to set the proper session account item: Set .SendUsingAccount = OutAppObject.Session.Accounts.Item(x) where x is the proper number for the mailbox we want to use.