LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Send an email attachment (pdf file) from Excel 2003 using Outlook Express

Hi Steve

Shall appreciate if someone can also help why first method is
failing...


You can't add a attachement to the mail in your code example.
Body is possible
http://www.rondebruin.nl/mail/oebody.htm

But CDO is the best way


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



wrote in message oups.com...
Ok..some developments...

I just got Ron's method to work. It work the way I wanted it...Thanks
Ron.

I don't know what exactly fixed the problem..these things were done...

1. Gave Excel permission to send mail in ZoneAlarm
2. Changed the From Email address from to my actual
Email address (of my SMTP server).
3. In Outlook Express, ToolsAccountsMailPropertiesServersOutgoing
Mail Server, unchecked 'My server require Authentication'.

Now luckily I have two SMTP servers, one requiring authentication and
one that do not. How do I give a password authentication through VBA if
I were to use the SMPT server which need authentication...

Shall appreciate if someone can also help why first method is
failing...

Thanks in advance



 
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
Outlook Email Send Dialog Boxes, Excel 2003 How to Turn Off or Rem Kit Excel Discussion (Misc queries) 0 May 11th 07 06:33 PM
Fw: send two or more files with Excel and Outlook Express Infosistem Excel Discussion (Misc queries) 1 August 17th 06 05:27 PM
How do use outlook express to send email in office 2003 How do use outlook express to send email Excel Discussion (Misc queries) 1 July 19th 05 12:35 PM
Cannot send out Excel workbook through Outlook Express Abel Chan Excel Programming 5 March 7th 05 03:34 AM
Send current Excel File as an attachment using Outlook 2000 ZABU Excel Programming 3 May 28th 04 04:50 AM


All times are GMT +1. The time now is 12:35 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"