Thread
:
Send an email attachment (pdf file) from Excel 2003 using Outlook Express
View Single Post
#
7
Posted to microsoft.public.excel.programming
Ron de Bruin
external usenet poster
Posts: 11,123
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
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin