Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
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) "Ron de Bruin" wrote: Why use both ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SHETTY" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
Have also just found out that we are running on a domino server?? does that
change anything? -- Thanks Lise (Aussie) "Lise" wrote: 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) "Ron de Bruin" wrote: Why use both ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SHETTY" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
Start with this page
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm If you want to CDO read all info good on the page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lise" wrote in message ... 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) "Ron de Bruin" wrote: Why use both ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "SHETTY" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
CDO mailing from Excel
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 "Mike" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
Excel mailing | Excel Discussion (Misc queries) | |||
e-mailing with excel | Excel Discussion (Misc queries) | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) |