VBA Unleashed: Send Customized Emails in One Line

VBA Unleashed: Send Customized Emails in One Line

Excel Macro Mastery

1 год назад

10,639 Просмотров

Ссылки и html тэги не поддерживаются


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

Excel Macro Mastery
Excel Macro Mastery - 18.07.2023 19:41

Let me know in the comments if you find the one line method useful for sending emails😀

Ответить
Sasif Excel Solutions
Sasif Excel Solutions - 14.09.2023 13:32

Thank you, off the topic, I watch almost all your videos, I'm looking for advanced filter where the source data is outside of the active workbook. Like code to open the workbook, run the advanced filter and the close the workbook. Thank you for you videos.

Ответить
Hammeed Abdo.
Hammeed Abdo. - 11.09.2023 05:40

Have you already explained all the principles of object-oriented programming, such as inheritance, encapsulation, abstraction, and polymorphism, through building applications to understand these concepts?

Ответить
Hammeed Abdo.
Hammeed Abdo. - 31.08.2023 01:20

New.....Now Python in Excel...Bye Bye VBA!

Ответить
ousmane tall
ousmane tall - 27.08.2023 16:09

Hi you're very professional, but your speed of teaching is too fast, and explanations are not enough. Please, I want to learn more from you and want you to be as understandable as possible. From Senegal, a country of africa

Ответить
Андрій
Андрій - 15.08.2023 16:46

Great video!!! It’s exactly what I was looking for❤

Ответить
José Carlos Conejo
José Carlos Conejo - 26.07.2023 20:34

Very useful well explained. You got a new subscription

Ответить
Ivan
Ivan - 26.07.2023 17:08

Hi. Quick question. How could one use a better code editor for vba? Is it possible to use Vscode somehow?

Ответить
Debbie
Debbie - 23.07.2023 09:59

Thank you for the great video. I love code that handles multiple options 😀

Ответить
Makubexho PC
Makubexho PC - 21.07.2023 02:47

Great video as always. Thank you Paul

Ответить
PB S
PB S - 20.07.2023 14:31

Very nice video and code. Will likely be using the code in the helper module in the future.
With some error handling when adding the attachments, that seems to be the most likely point of failure, it seems to be very close to ready to use.
I will probably integrate also your solution to add charts without using the Clipboard, and make sure to credit you on all the code!

Ответить
John Maxwell
John Maxwell - 19.07.2023 23:08

Do you have a solution for using an other "from email" ? I don't think that works good anymore with Office365 and outlook.

Ответить
Abdul Rehman Mughal
Abdul Rehman Mughal - 19.07.2023 13:03

hi sir hope your doing well, Thanks for your contribution in excel vba learing, I have a question when the email send by vba how can i check if the email is not delivered or not without opening outlook by code at the specified email address.

Ответить
Jonathan R
Jonathan R - 19.07.2023 04:38

Using the same approach as you have in this video, are you aware of a good way to pass through a graph object to the send email function so that the graph is included in the body? I cannot find any good support for it so end up copy/pasting the graph which then ties up the clipboard (which I want to use for hyperlinks since passing through an array destroys them..)
Great video!

Ответить
RODS
RODS - 19.07.2023 04:12

Been doing this since early 90's for sending quotations proposals and product info etc No more fax machines secretaries etc could prepare and send a quote in 30 seconds.

Ответить
Karl Lee
Karl Lee - 19.07.2023 04:02

Another amazing video. I send many emails and this function can come in very handy. Thank you for putting it together!

Ответить
BUDI YANTO
BUDI YANTO - 19.07.2023 02:42

Excellent. Another great lesson. Thank you Paul ❤❤❤. Request for the next lesson “Sending Whatsapp masssages using VBA”. 😁

Ответить
anthonygeo3
anthonygeo3 - 19.07.2023 00:23

Great video as per! Super clear and logical steps to guide you from one end to the other. Thanks

Ответить
twiddle7125
twiddle7125 - 18.07.2023 20:52

All I had to do was move the .Display and use the .HTMLBody?? I researched forever to try to get my signature to be included....

I am experiencing a weird bug, though. I am adding an html span tag to specify my typeface and size since it won't use Outlook's default for some reason, but I can't set the size to 12....I tried 16px and 12pt, but those come out as 10. All other values of px and pt correctly translate as expected....I'm losing my mind with this bug, lol. 11.5pt yields 11.5, 13pt yield 13, but 12pt yields 10. 18px yield 13.5, 14px yields 10.5, but 16px yields 10....whyyyyy? lol

Ответить
K M
K M - 18.07.2023 20:17

This is a great one! 🤩

Ответить
Artem
Artem - 18.07.2023 20:07

Thanks for your videos, Paul! 😊 Can I ask you a question? Is your main full time job VBA coding? If so, what kind of job is it? I was wondering If one can still get a job as a VBA developer

Ответить