ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Alternative to send mail (https://www.excelbanter.com/excel-programming/312040-alternative-send-mail.html)

steve

Alternative to send mail
 
Is there anything that I can do in VBA that will allow me
to populate the body of an email. Sendmail does not allow
me to do this.

Thanks
Steve

Ron de Bruin

Alternative to send mail
 
Hi Steve

http://www.rondebruin.nl/sendmail.htm

CDO is also a option
See the link on the webpage



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
Is there anything that I can do in VBA that will allow me
to populate the body of an email. Sendmail does not allow
me to do this.

Thanks
Steve




No Name

Alternative to send mail
 
Ron

Thanks for that.

Is there a way of changing the sendmail subject to have a
date that is today minus three days ?

Steve
-----Original Message-----
Hi Steve

http://www.rondebruin.nl/sendmail.htm

CDO is also a option
See the link on the webpage



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in

message ...
Is there anything that I can do in VBA that will allow

me
to populate the body of an email. Sendmail does not

allow
me to do this.

Thanks
Steve



.


Ron de Bruin

Alternative to send mail
 
Hi Steve

Format(Now - 3, "dd-mm-yy")

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ...
Ron

Thanks for that.

Is there a way of changing the sendmail subject to have a
date that is today minus three days ?

Steve
-----Original Message-----
Hi Steve

http://www.rondebruin.nl/sendmail.htm

CDO is also a option
See the link on the webpage



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in

message ...
Is there anything that I can do in VBA that will allow

me
to populate the body of an email. Sendmail does not

allow
me to do this.

Thanks
Steve



.




No Name

Alternative to send mail
 
Thank you Ron
-----Original Message-----
Hi Steve

Format(Now - 3, "dd-mm-yy")

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message

...
Ron

Thanks for that.

Is there a way of changing the sendmail subject to have

a
date that is today minus three days ?

Steve
-----Original Message-----
Hi Steve

http://www.rondebruin.nl/sendmail.htm

CDO is also a option
See the link on the webpage



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in

message ...
Is there anything that I can do in VBA that will allow

me
to populate the body of an email. Sendmail does not

allow
me to do this.

Thanks
Steve


.



.



All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com