LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Patrick
 
Posts: n/a
Default Add comments into email body using VBA

You need to fill in the smtp server name in your code. These may help.

How do I send e-mail with CDO?
http://www.aspfaq.com/show.asp?id=2026

Sending mail from Excel with CDO
http://www.rondebruin.nl/cdo.htm


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Noemi" wrote:
| Hi Dave
| I used CDO.Message and I got the error.
| I haven't tried using CDONTs.newmail
|
| I think I will just forget the main body of the email and use the subject
box.
|
| Thanks for your help.
|
| Noemi


 
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
Improrting Text file to a matrix when things are not constant. underdrain Excel Worksheet Functions 0 September 28th 05 04:00 AM
Range of Cells to create body of email Hahndo Excel Worksheet Functions 1 September 26th 05 07:00 PM
Email Macro with Outlook Express Moe Excel Discussion (Misc queries) 2 August 10th 05 02:50 PM
excel emailed as the body of email loses formating [email protected] Excel Discussion (Misc queries) 0 March 29th 05 01:57 AM
body of email disappears when I send an email from Excel ~A Excel Discussion (Misc queries) 0 February 25th 05 10:55 PM


All times are GMT +1. The time now is 03:30 PM.

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"