Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



.



  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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


.



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
Send an e-mail Pa Maher Excel Discussion (Misc queries) 1 September 16th 07 04:27 PM
Send e-mail Andrea Excel Discussion (Misc queries) 3 March 25th 07 12:37 PM
Send mail with attachment Jos Vens Excel Programming 4 October 31st 03 08:13 PM
Send Mail janet Excel Programming 2 July 22nd 03 10:06 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"