Email via SMTP (Simple Mail Transfer Protocol) with Excel VBA

[Sufiyan97]

Hello Everyone,

Is it possible to send e-mail with VBA via SMTP, if it is possible then I need help to create VBA for it.

Book1
	A
1	From
2	To
3	Subject
4	Email Body
Sheet1

 

[GWteB]

You could take a look here ...

Send Email from Excel using VBA and VBScript - Tutorial

 

[Sufiyan97]

Ok I will look at it and let you know if query, I believe I will have because I am not familiar with VBA

 

[6StringJazzer]

Do you really want to connect directly to an SMTP server? Or is what you really want to do Send an email"?

 

[Sufiyan97]

Do you really want to connect directly to an SMTP server? Or is what you really want to do Send an email"?

Thank you 6StringJazzer for reply

I really want to do Send an email.

 

[6StringJazzer]

Do you use Outlook? It is fairly straightforward to use VBA to send an email through Outlook.

It is possible to do it other ways as well but Outlook is integrated into VBA.

 

[Sufiyan97]

Do you use Outlook? It is fairly straightforward to use VBA to send an email through Outlook.

It is possible to do it other ways as well but Outlook is integrated into VBA.

I use outlook but I want find a way to send mail via SMPT without outlook.

 

[daverunt]

Look at CDO.

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

It just chucks the mail at the SMTP server

There's a recent post on it here also.

CDO mail

I need the code to send CDO mail to a gmail account. I have tried many times to get Ron de Bruins code to work but just can't get it. Sub SEND_PDF_SHEET_WITH_CDO() Dim filepath As String filepath = Environ$("temp") & "\" & ActiveWorkbook.Name & ".pdf" 'TODO:change filepath for the temp pdf...

www.mrexcel.com