CDO mailing from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHETTY - 24 May 2008 06:55 GMT

Dear Friends

I am trying to use sample code by Ron de Bruin for sending mail from Excel

I want to send text string as well as html image in the body of the mail

I am unable to use both at a time
.TextBody
.HTMLBody

Please advise

Rgds

Ramesh Shetty

Reply to this Message

Ron de Bruin - 24 May 2008 18:55 GMT

Why use both ?

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Dear Friends
>
[quoted text clipped - 11 lines]
>
> Ramesh Shetty

Reply to this Message

Lise - 31 Jul 2008 23:52 GMT

Hi Ron

I have been looking at your site but am receiving an error message when
trying to setup the email option - when entering the info to see if I can use
the CDO I receive the following:
run-time error '2147220960(80040220)'
The "Sendusing" configuration value is invalid. = error 404

As this is all very new to me - is there something obvious that I am doing
wrong?

Thanks

Lise (Aussie)

> Why use both ?
>
[quoted text clipped - 13 lines]
> >
> > Ramesh Shetty

Reply to this Message

Lise - 01 Aug 2008 04:19 GMT

Have also just found out that we are running on a domino server?? does that
change anything?

Signature

Thanks

Lise (Aussie)

> Hi Ron
>
[quoted text clipped - 28 lines]
> > >
> > > Ramesh Shetty

Reply to this Message

Ron de Bruin - 01 Aug 2008 04:19 GMT

Start with this page
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

If you want to CDO read all info good on the page

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi Ron
>
[quoted text clipped - 28 lines]
>> >
>> > Ramesh Shetty

Reply to this Message

Mike - 03 Aug 2008 02:22 GMT

Ron, I adopted your example code on http://www.rondebruin.nl/cdo.htm and it
works very well (Thanks!). One thing, though. I like to use early binding
when possible. Do you know how I would declare iMsg and iConf to accomplish
this? Thanks.

Reply to this Message

Mike - 07 Aug 2008 14:35 GMT

OK, I had to reference the Microsoft CDO for Windows 2000 Library and not
the CDO 1.21 library. Code becomes as follows

Dim iMsg As CDO.Message
Dim iconf As CDO.Configuration
Dim Flds As Fields

Set iMsg = New CDO.Message
Set iconf = New CDO.Configuration

> Ron, I adopted your example code on http://www.rondebruin.nl/cdo.htm and
> it works very well (Thanks!). One thing, though. I like to use early
> binding when possible. Do you know how I would declare iMsg and iConf to
> accomplish this? Thanks.

Reply to this Message